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

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