How do I find a mode while disregarding a specific cell value?

G

glasskit

I would like to create a function that finds the mode of a range of cells,
but does not consider a particular value in the range.
 
P

Peo Sjoblom

=MODE(IF(C1:C8<>4,C1:C8))

entered with ctrl + shift & enter will not consider 4

Regards,

Peo Sjoblom
 
Top