Hello! I have an excel spreadsheet that came from an Accounting report that was laid out like this: CUST0099 INV9880 09/06/02 1456.09 INV9767 09/01/02 ...

I'm not sure if this is an easy question or not: I have a spreadsheet with cells that have an IF function in a formula. When the IF function criteria is not...

I'm trying to count the number of cells that are greater than "26 wks". When I use Countif(S3:S82,"=26 wks") I also get the cells with 3 wks, 4 wks, 5 wks, 6...

Stupid question, but how DO you add a custom function in the new Excel? I used to rarely do this in older versions, but I cannot seem to make it work now. Is...

Hi, I am in a lottery sindicate at work and we purchase numerous entries (lines) for each draw. I need a way to enter the latest draw and let it lookup the...

I have a spreadsheet done. Column D will let be marked with an X if need to be ordered. Column E has price of said product. I would like the total to be at...

Thank you guys sooo much!! I am sooo relieved :) Dawn

I exported payroll data from Quickbooks into Excel and it went in as a Pivot Table. I have several columns, the first being Soc. Security Number and it is...

Hi Everyone, Can anyone help? I have an excel chart which you could think of timing an item on an assembly line.. but in days. There are 500 rows (item...

I don't see your screen shot, but you can use the SUMPRODUCT function to calculate visible cells after a filter has been applied. For...

Everybody that helped me in my previous question was a great help....thanks! Now, I have this and it...

Bob, It does work when using the same format of the cells ie.. 2 wks, however some of my cells contain "stk", "stock" and 0 (zero) and I need to keep these...

I want to repeat the left column of my worksheet on each page. Some cells have information that is fully contained in the cell, and some are description...

Ok, here is the deal. I have 52 columns (one per week) and 10 rows (representing top 10 sellers). The top 10 lists are store names such as 'Mall of America',...

What is an expedient way to search an excel worksheet, find and delete blank rolls withouthaving to manually scroll through the blank rows.

I am trying to set up a worksheet to randomly sellect a certain percentage of itmes from a list. I need to slect text data, and I need to be able to change...

when using auto filter how do you get stats to appear on the status bar (ex. 56 of 100). some of my worksheets have it while others say "filter mode"

While hiding some columns in a worksheet, I accidently hit save. How can I unhide the columns and retrieve all the data.

In Excel is there anything like the Range Value command in Lotus which I used to blow away a range of cells' formulae while leaving behind in the cells the...

I need a formula to make a total show up in another color if it is not equal to another cell. How do I do this?