I need to do a "reverse" advanced filtering. In other words, I need to highlight a column of names and seperate the "non" duplications. When I do the advanced...

I have a user who wants a simple count of nonblank cells. But he wants the count to skip cells that have a space (or two or more) in them as well. My formula...

What does a "plus" cursor mean (in lieu of the pointer?)? thanks

The following formula presumes there is data in N75 and J75 =IF(ISNUMBER($R75)*($R750),"",IF(AND($N75-$J750,$Q75=1),0,$N75-$J75)) When no data can be...

Hello. I am fairly familiar with Excel and have been racking my brain trying to figure a formula out. Here is the scenario. The military uses dates in this...

I've perused the existing posts and while I've come across some useful postings, I couldn't seem to find my exact answer. I simply want Excel to calculate the...

Is there a way that I can change all of the hard 8's entered into a worksheet (not the 8's resulting from formulas) to all hard 9's without re-typing all of...

I have a sheet with data in 4 columns. Column A is the clients name, address and city. Column B is the state the client is in. Column C is the zip code of...

I have the following formula working well, however as there is a limit of 7 nested functions and need some more, what is my options? =IF(B5="P-NE","Pre App...

Can anyone help me figure out a formula for the following sliding bonus scenario: To receive a bonus, Gross Profit must be at least $250,000 Once minimum is...

Hi, can anybody advise (or direct me to basic creation site) where I can create a dropdown menu in excel. the menu will hold seveal options ie Food, Drink,...

I am using Excel for a long time now and it always worked fine. But one week ago it started to crash my whole system whenever I close it. This even happens...

$25000 mortgage 7.25% APR 15 years starting first payment September 1,. 2004. Appreciate any help^

I use the hlookup, vlookup and lookup functions in Excel a lot -- they're really powerful for building automated reports. It's annoying that they return #N/A...

Is there a way to link one cell to multiple worksheets? I would like to have the option to select data from one worksheet or another worksheet.

I have 5 worksheets in my workbook, one being the main one with a graph that summarizes the totals from the other sheets. How do I get so I don't have to keep...

Excel 97 - i need to merge 2 fairly large workbooks, however i cannot use "compare and merge" because my workbooks are not direct copies of each other. There...

Me again ... while I am here ... My spread sheet contains a first column with unique values and the remainded of the colums are referenced in another...

I have an age column and a DOB column, What is the formula to calculate the age by using the date of birth.

i had a unique problem. i have to calculate interest on some amount with relation to some period of fiscal year. for ex interest on 100 from 1/7/2000 to...