| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
exluding missing data values from equation
We are required to specify why data is missing and we have therefore given it
a number value (eg 999 for missing, 777 for not applicable). However we need to be able to exclude these values from the final calculation in order to get the correct answer. What can we do??? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumproduct issues | Excel Worksheet Functions | |||
| Return Matched Numeric Values across Rows | Excel Worksheet Functions | |||
| Sort pages? | Excel Discussion (Misc queries) | |||
| how do you prevent data from changing values when sorting linked . | Excel Discussion (Misc queries) | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Threaded Mode
