The discussions

Excel formulas

 Solved

Hello, I am having difficulty copying fromulas on excell from different sheets to form an analysis page. I have 52 different sheets and need to ...

30 replies Last reply on 23 Aug 2010 by
rizvisa1

Compare two excel columns

Hello, I have two excel sheets. One has Server Names only. Second has server names with other columns with more data like OS,Supplier,Application...

1 reply Last reply on 23 Aug 2010 by
Game Start Now

Excel - formula in text count

 Solved

Hello, I Need a formula in text count For Example P=1 P+P+P+P+P= 6 What is the formula in excel please defineConfiguration: Windows XP / ...

3 replies Last reply on 23 Aug 2010 by
sk

Ms word document

Dear all please suggest me how to create ms word document in samsaung star?

1 reply Last reply on 23 Aug 2010 by
cha_mps

Copy / paste specfic date to other worksheet.

 Solved

Hello, I've got a few columns of data in which 3 columns contain dates (in date format : dd/mm/yyyy) . Now, I want excel to seperate the entire row ...

11 replies Last reply on 22 Aug 2010 by
carman

How to open mobile 6630 password

 Solved

how can I break my forgetting password of mobile 6630 thanks

4 replies Last reply on 22 Aug 2010 by
Ambucias

Getting some one's yahoo id's password

Hello, Dear sir I want to get someone's Yahoo ID's password whitout having his/her security questions,Only I have his email ID and be quick. Thank...

2 replies Last reply on 22 Aug 2010 by
rina

Date counting in excel

Hello, How can I count rage of date in excel? Configuration: Windows XP / Internet Explorer 6.0

1 reply Last reply on 22 Aug 2010 by
Game Start Now

Need password for dell d620

 Solved

The origanal hard drive stopped working. I bought a new one and when I turn it on it asks me for a system or administator password. I have no idea. Sy...

3 replies Last reply on 22 Aug 2010 by
cha_mps

Forgot pword in win.7

Hello, i m sundeep.i forgot my pword in windows7.how i login to my account? Windows 7 home premiem

1 reply Last reply on 22 Aug 2010 by
jaunglia

Recover old deleted messages

Hello, i need or recover my old deleted messages from my hotmail ID " ktkoooth_30559@hotmail.com. message recoverd from 1/1/2008 to 1/8/2010 t...

1 reply Last reply on 22 Aug 2010 by
jaunglia

Find and replace cell value macro help pls

 Solved

Hello, i have these 20 formulas (1 per stock code) in my spreadsheet that come from etrade =PROStaticData(2, "mqg.ASX", "2010/08/10;2010/08...

6 replies Last reply on 21 Aug 2010 by
jonny

Read:phone lock password for samsung gt-s5230

 Solved/Closed

Hello, i have forgotten my phone lock password for my phone and I dont have a clue how im going to unlock it again... if you could help me I would b...

Last reply on 21 Aug 2010 by
Ambucias

If one cell contains a name then?..help.help.

 Solved

Hello, I have a 2 columns in (Worksheet 1) . One with Names (A1) and the other with Numbers (B1) corresponding to the names. On (Worksheet 2) (C1...

2 replies Last reply on 21 Aug 2010 by
Neil

Swapna

Hello, How to put nested formula for Date-time column? I want to segregate data into different time slab. Please Help

1 reply Last reply on 21 Aug 2010 by
cha_mps

Filtering problems

 Solved

Hello, I have a microsoft database access and I'm trying to filter some records. This is what I do: 1. I have a form for query purposes, in tha...

4 replies Last reply on 21 Aug 2010 by
Cindy

Forget my password

Hello, I FORGET THE PASSWORD OF AN MICROSOFT EXCEL-2007 FILE AND I AM NOT IN A POSITION TO OPEN THE SAME KINDLY ADVISE ME IN THIS REGARDS. WI...

2 replies Last reply on 21 Aug 2010 by
chaminda

Auto summation?

Hello, I need help in a macro I'm working on. Right now I have different sets of data arranged in the following manner as an example D32 Colum1...

5 replies Last reply on 20 Aug 2010 by
JayHerring

Need help with excel!!!

Hello, I have two sheets with 5 columns each; item number, description, quantity on-hand, price & total value. I want to match the columns on shee...

2 replies Last reply on 20 Aug 2010 by
JayHerring

Macro: watch a cell and copy if changed

 Solved

Hello, The problem in a nutshell is that I have 5 pivot tables on one worksheet, each with a field called "date" above the main text. Each day the...

4 replies Last reply on 20 Aug 2010 by
JayHerring

If statements...causing trouble!

Hello, I'm trying to figure how i would create a formula that would capture the following... If E7 is >=1 but =4 but =7 but

1 reply Last reply on 20 Aug 2010 by
IneptMacro

List unique values from multiple columns

Hello, I am kind of new in advanced programming with Excel. I have a table that gathers a number of sentences which I classify with 3 category c...

2 replies Last reply on 20 Aug 2010 by
Swami

Forgot my password

Hello, i have 1GB micro sd card & i have forgotten its password now it is blocked so help me in opening

1 reply Last reply on 20 Aug 2010 by
jziutsa

Excel2007 copy cell from sh1 to sh2 range

Hello, I would like to copy the variable text content of Cell K8 on Sheet2 to a cell range of D6 to D35 on Sheet1 so that the text entered into K8...

2 replies Last reply on 20 Aug 2010 by
jziutsa

Search for accounts balances excel or access

Hi guy's, I need your help with the following problem. I have a list of accounts in an Access Database, each account has a balance next to it. ...

1 reply Last reply on 20 Aug 2010 by
rizvisa1

Excel formula add data if columns match

Hello, I am basic excel user who is slowly needing to use formulas. I have two seperate charts that I've put into 2 worksheets with similar informati...

3 replies Last reply on 20 Aug 2010 by
rizvisa1

Display data based on selected column name

Hello, I have two worksheets in my excel sheet. The first sheet contains data as shown below. It has data for each month. ...

2 replies Last reply on 20 Aug 2010 by
rizvisa1

Matching a cells in different columns

Hello, I want every cell in Column A find a matching cell in Column B, if there is a match, then I want results shown in column C in the same row ...

1 reply Last reply on 20 Aug 2010 by
rizvisa1

Read data from excel 2003 to write to sql

Hello, Help please I have to read data from Excel 2003 to write to SQL server using .net, so every time user modify data it shuld refelect to...

1 reply Last reply on 20 Aug 2010 by
rizvisa1

Excel formula help

Hello, I have the following problem and need someone to help me solve it. I want to concatenate items in column A, but it must only concatenated ...

1 reply Last reply on 20 Aug 2010 by
rizvisa1

Overtime

Hello, This is a tough one and if somebody can figure it out I praise you. I have a simple spreadsheet but to calculate overtime is tough. A2 th...

3 replies Last reply on 20 Aug 2010 by
rizvisa1

Excel formula clarification

Hi Guys and Gals, Is there a formula that can make the value of any given cell always display the 1st day of the current month? I am aware of th...

4 replies Last reply on 20 Aug 2010 by
rizvisa1

Excel formula - delete rom if not ".pdf"

Hello, I am having the most troubling of times trying to find the google answer to this question. I stumbled upon this forum and many of you seem...

1 reply Last reply on 20 Aug 2010 by
rizvisa1

Auto populate cells from bottom to top vba

Hello, i would like write a vba script to fills the blank cells with the value of the cell directly below it starting from top to bottom with a loop...

1 reply Last reply on 20 Aug 2010 by
rizvisa1

Copy paste row to a new worksheet

Hi everyone i am stuck with this problem, i have 40 lines in my excel spreadsheet..how can i do a macro that it will copy and ...

1 reply Last reply on 20 Aug 2010 by
rizvisa1

Retaining similar values in cells

Hello, I need a solution with retaining similar values in excel sheets. I have a list of words like: Mount Prospect IL Multi-Family Mortgages M...

1 reply Last reply on 20 Aug 2010 by
rizvisa1

Ms excel

Hello, I want to know whether a particular information from one excel sheet can automatically get copied in the other one as soon as a particular cr...

1 reply Last reply on 20 Aug 2010 by
rizvisa1

Easiest way to sort and find/display

Hello I'm looking for the easiest way to manage, sort, find, and display about 300 cross country runners statistics. In column A, I have dates; i...

1 reply Last reply on 20 Aug 2010 by
rizvisa1

Populating a list based on a specific value2

Hello, It's me again, this time bringing with me an example of what i'm trying to do. as you can see, there is a macro that generates more lines an...

1 reply Last reply on 20 Aug 2010 by
rizvisa1

Microsoft office 2010 wont pick 2003

Hello, I recently purchased and dowloaded office 2010 . my professor posted a syllabus online which uses microsoft word 2003, and now when i try to...

1 reply Last reply on 20 Aug 2010 by
jziutsa

Excel autofill macro for different data cells

Hello, I am looking to create a macro that will enable autofilling different rows with the data in the top cell. Here is an example: Row ...

1 reply Last reply on 20 Aug 2010 by
rizvisa1

Create a macro to format a column

 Solved

Greetings, I am not a programmer but I know how to create basic macros that would perform simple repeated tasks in a fixed range within a sheet. ...

3 replies Last reply on 20 Aug 2010 by
Vivian

Change cell value based on another' color

Hello, I want to change the value of Cell O21 the following way: If D21 is Green, change it to N21 If D21 is Yellow, change it to 0.5*N21 If D21 ...

3 replies Last reply on 20 Aug 2010 by
rizvisa1

Macro to delete duplicate items -help please

 Solved

Hello, I'm trying to create a macro to delete the row that has a word at the biginnig and the same word at the end. Example: MIA/SFO/MIA ...

5 replies Last reply on 20 Aug 2010 by
rizvisa1

Technics to unlock administrative passwords

 Solved

Hello, Can you help by showing me how to unlock a computers with an administrative passwords if theres no unlocking software? Configuration: Wi...

1 reply Last reply on 20 Aug 2010 by
Ambucias

Fictitious messages in outlook outbox folder

Hi, I wonder if anyone can suggest a solution to a problem that I have. I'm using Outlook 2003 and the program seems to have got confused. For ...

1 reply Last reply on 20 Aug 2010 by
Ambucias

Lost information on excel after saving it

Hello, I have lost all my work that I have entered into Excel after saving it in Excel 97-2003 Workbook. How can I get the information back? I h...

1 reply Last reply on 20 Aug 2010 by
cha_mps

Very urgent. downloading any document in word

Hello, whenever i download any word document from the web it opens in PDF format which i am unable to access, so please help me in downloading any...

1 reply Last reply on 20 Aug 2010 by
cha_mps

Excel: date+1 year?

Hello, I am trying to set up a simple way to let my excel illiterate boss have a simple way of knowing when a list of products need to be updated. So...

5 replies Last reply on 19 Aug 2010 by
richardb

Sum with conditions but look at date

 Solved

Hello, I want to sum the conditions in a certain month. Say for June from the 1st to30th or July 1 to 31. The formula that is used without the date ...

2 replies Last reply on 19 Aug 2010 by
Gouws
Results 7451 - 7500 out of a total of 12,269