The results of the following formula is 0 when column G has values in it. =SUM(IF($B$6:$B$65536="John Doe",IF($B$6:$B$65536="Jane...

I opened a new worksheet while still working on saved one. Did not realise that when I saved it saved it over the previous one. Is there any way to...

I need to save my file in a csv format. When the file is reopenned, some of the numbers are in a date format and others are in exponential format. How can I...

How do I create an autofilter for columns that are not next each other? Example, COLUMN A and COLUMN C may be the only columns that are important for my...

Try adjusting the contrast on your computer monitor. Mine are little buttons on the lower right just below the screen. My contrast was turned up on high, when...

Hello, I have Excel 2007 I have a series of increasing numbers which have been trucated (rounded down) to integers , eg 2, 2, 2, 3, 3, 3, 3, 4, 5, ...

Hello, I'm sure this is simple for someone: I have a list of items with counts. On the last row for a particular item, I want to add up the counts for each...

I have the following columns: Job Title, Week, Total People The data looks like this: Job Title Week Total People PM W2 ...

i need to do a weekly schedule for a painting company with a place to put the work order numbers and hours in each job, i have excel 2003, how do i do...

kontaktanzeigen bochum kontaktanzeigen münchen russlanddeutsche kontaktanzeigen kontaktanzeigen abkürzungen transen kontaktanzeigen + +

Hello I have made an excel workbook in excel 2000. sheet1 = Invoice sheet2= Products sheet3= Customers sheet4= Suppliers sheet5= OverView I have been able to...

I'm trying to enter records into a spreadsheet. everytime i Try to use a dash, it converts into a date

..I am just turing to Take a Total (B2) and subtract b4:60 and I get a value error message. My formula looks like this =Sum B2 - B4:B60 What I I doing...

I tried to make a macro to do this, but I failed. I need to do this: in the same row I want to copy the contents of one cell and then copy the same contents...

Hello, Using an older version, MS Excel 97 Some simple stuff, but I have a single column of numbers that for some reason, is taking up two row spaces, while...

hi, i got notify mail and when i try to open that it displayed blank page

hi, priter setup is being displyed first while i opening excel worksheet can you help me with this issue??

I have a large spreadsheet with part numbers and prices. Have a second worksheet with part numbers and special prices. I want to have the first sheet cell...

hi, when i open my excel sheet it is displaying first printer setup and after clicking thrice only iam able to see the work sheet can you please help me...