Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Ommitting 0 from a mode calculation.
Hi,
Is it possible to make a mode calculation but if one, or many, of the values is equal to 0 then it is not included in the calculation. So that if you have values of 15 "3"'s and 5 "0"'s then the mode will be 3. But if you had 15 "0"'s and 5 "3"'s the mode will still be 3. Hope that makes sence. Thanks, Steve |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Set Calculation mode for a single worksheet | Excel Worksheet Functions | |||
Open CSV causes calculation in manual calc mode | Excel Discussion (Misc queries) | |||
type mismatch on saving excel calculation mode via VB app | Excel Discussion (Misc queries) | |||
My Calculation Mode Changed to Manual Somehow?!? | Excel Discussion (Misc queries) | |||
Book1 changes itself? | Excel Discussion (Misc queries) |