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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Ommitting 0 from a mode calculation.
Hi Steve
One way using an array formula {=MODE(IF(A1:A300,A1:A30))} Use Ctrl+Shift+Enter (CSE) to commit on Edit the formula rather than just Enter. Do not type the curly braces { } yourself, Excel will enter them when you use CSE Change range to suit -- Regards Roger Govier "Steve" wrote in message ... 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 |
Reply |
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) |