I can't get a result for the following If a1=1 or a2=2 and a3=3 then a4=4 otherwise 0

I was previously using Excel 2002 and decided to buy Home and Student non-commercial 2007. I am having problems converting my 2002 files to 2007 and also do...

A B 1 Date Successful 2 10/1/09 Y 3 10/1/09 N 4 10/5/09 Y 5 11/3/09 Y I want to put a formula into a...

I have created a chart from data on a spreadsheet. How do I automatically update my chart with new data(row) added to the spreadsheet. Regards, Al

HOW CAN I COMPILE 2 SHEETS? n tell me what is the formula of subtraction in it? how can we repeat the same row in all pages of a sheet (in printing)...

Hi guys, I have a big worksheet with a ton of columns, what I need to do is find all the numbers from column B that are in column A and create a list of...

I have two worksheets. Sheet 1 contains a number in column A and a name in column C. On Sheet 2 I put my data from a csv file. What I would like to do is...

I have 3 conditions MPn and Vendor code and Mfg code must be correct before the vlookup function can search for the correct data. I tried to use the...

Hi all you brain boxes out there. Need some help please. I have a book with about 10 different sheets in it. What I am after is a way to copy the information...

Thanks Mike

Hi Folks, need a hand please. I have an excel book with about a dozen sheets in it. I have information in one row of cells that on pressing a button will...

I'm trying to import a text file into a blank xls file. It has delimters of bars (I guess - looks like an l with nothing at the top or bottom.) It works fine...

I would like to know how to procedd to obtain the following results: if F8 background color=CYAN then k8=j6 other wise nothing happens. Thanks

Hi. I'm used to operating in Access, but need to do some analysis in Excel because my users don't have Access. I have a worksheet called "Master" with a...

Using Excell 2007 and can not figure out how to print the contents of only one cell at time?

Need help (again) I have an Excel 2007 worksheet column that contains a calculated average of some daily postings. Is there a way to change the font color of...

Just got the new version of Excel (2010) and I opened an older version document. The older version of the document had nine different sheets. Now I can't...

I am trying to import notes from a current data base program, which I exported into excel, into a new database program which requires me to match a unique...

i am trying to put info in a cell. i need to double space so it will fit. i changed the size of the cell but ther is space above my words there fore i...