Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Another excel query
If I have a long series of numbers in a column, I want each number (whether
it is between 2 and 9) to represent the number 1, regardless of its size. This is so that I know how many guests I have invited; however, their responses correspond to certain codes (i.e. 2 = refused, 3 = interested etc) for which I have used the COUNTIF formula. Obviously adding up the contents of the column suggests that I have invited far more people than I had! Hope that this makes sense. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Another excel query
Look up the COUNTA formula in Help. That will count the number of occupied
cells in a range. Post back if you need more. HTH Otto "MacSeoinin" wrote in message ... If I have a long series of numbers in a column, I want each number (whether it is between 2 and 9) to represent the number 1, regardless of its size. This is so that I know how many guests I have invited; however, their responses correspond to certain codes (i.e. 2 = refused, 3 = interested etc) for which I have used the COUNTIF formula. Obviously adding up the contents of the column suggests that I have invited far more people than I had! Hope that this makes sense. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using A Cell In Excel as Criteria for a Query | Excel Discussion (Misc queries) | |||
Excel 2000 using Web Query is slow on Excel 97 | Excel Discussion (Misc queries) | |||
enable automatic refresh | Excel Worksheet Functions | |||
AHHH! Again | Excel Discussion (Misc queries) | |||
Micosoft Query does not export result set to excel | Excel Worksheet Functions |