I have a simple formula--which sums the numbers in a list. However, when I change a number in the list, the total number is NOT changing. The formula is...

I have been researching and trying to figure out how to get a spreadsheet do some counting for me. I am on active duty with my National Guard unit on a...

=IF((C3=1,I3=100%, IF(C3=2,.I3=.80, IF(C3=3,I3=1.25, IF (C3=4,I3=0, If(C3=5,I3=0))))))

Pulling a value into a cell is easy. But can you go the other way, ie, can you send text to another cell and then have that cell be a value not a formula? Or...

I need to freeze several rows at the top of my spreadsheet and several at the bottom so that both the top and bottom remain in view whilst a user scrolls...

I'm trying to create a list of models from a column that has multiple models with duplicate entries. example: column a model b model c model b model a model a

I have a large qty of numbers within a column with many duplicates (2300+ rows). What function can I use to find and eliminate all duplicate numbers?

When formatting a cell using this format code : +0,00%;-0,00% it is displayed correctly (red for negative values, green for 0 or positive values) When using...

I would like to calculate the year a person turns 70 1/2 years old. I have the birthdate and would like to have some kind of formula that would give me the...

If I have a column of Dates and I need to extract all of them between a given date range (ie. between 2/3/03- 3/1/03) how can I do this?

Is there a way to control how text appears when entered into a cell? I want to create an input mask that capitalizes all words in an address field no matter...

Other than sorting, does anyone know how to delete all blank rows from a report in excel. The reason we need this is b/c we have a software aplication that...

When I hit Cntrl. End the cursor goes many many cells and columns into the sheet. There is very little actual data in this sheet and I would like to reset...

Anybody know how to make Excel increment by actual calender months. The DateValue function has a problem. I want to create a column of month, day,...

I have a nested IF statement that is complex and DRIVING ME CRAZY!!! It comes from a QuatroPro Worksheet but I can't figure out what I am doing wrong with it...

I have created several marco's in Excel and they work great when you map to the drive they are on and run them normal. If you try to run them through Explorer...

If I have 4 cells, and I want the minimum value greater than zero of the 4 cells, how do I write this? Example A2=3 B2=8 C2=0 D2=9 I want the formula (in...

Does anyone know how to stop the Review toolbar from appearing when starting up Excel 2002? Even when I remove the toolbar from my View, it always pops up...

I want to flip my heading row so that the fields are listed down the side instead of across the top. Is this possible?

I need to put a search engine on an Excel spreadsheet. This spread will contain various names, up to 2000 and I need an easy way to find these names, I need...