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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to Select text from a point given to a specific word 2
Finding the proper style field and the numbered paragraph value within the style 0
Finding the right style field in VBA 0
External cell reference between two excel worksheets both in One Drive 0
Copy addition formula of non-consecutive horizontal cells 2
Drop down list control value in vba 2
Finding location (or start cell) of highest consecutive values 3
SUMIF with criteria "<>" & "=" 4

Top