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
|