What formulea do I use to find a the number of cells with a value greater
than 20 but less than 30 in a range of cells B2:B32 in Excel 2002
- May 16 Wed 2007 20:37
Find value grater than X but less than Y
- May 16 Wed 2007 20:37
autofit columns in pivot table
I am using Excel 2002.
Whenever I change the order of the row items in the layout of a pivot table,
- May 16 Wed 2007 20:37
ANOVAs Excel 2000
installed the data pack, and it says that I can do ANOVAs. Each time I
setup the data, I can not get any data out of the analysisI such as Sum of
- May 16 Wed 2007 20:37
Help on any part of this would be great
- May 16 Wed 2007 20:37
Formula partial result displayed in cell
My formula =D3*0.0275 850 displays the '850' in the cell without yet having a
value in D3. I know how to avoid having zero values displayed, but how do I
- May 16 Wed 2007 20:37
Entering dates
I am trying to set up a timetable spreadsheet that will allow users to enter
the time as 4 digits and then Excel converts this automatically to the
- May 16 Wed 2007 20:37
Mind Gone Blank!!
My wife has asked me to create a sheet that will give her the following
info.
- May 16 Wed 2007 20:37
How do I lock selected cells, so only I can change them?
I need to lock only a few certian cells in my exel sheet, so they can not be
changed by other users. Is this possible, and how can I do that if it is
- May 16 Wed 2007 20:37
Sumproduct arrays
Hello Excel Users and Experts,
- May 16 Wed 2007 20:37
Prompt to save file
I seem to have forgotten where you set up an Excel spreadsheet to have a
message box pop up on the screen to prompt you to save the file every e.g.,