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
|