View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Steve Steve is offline
external usenet poster
 
Posts: 1,814
Default 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