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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
=MODE(IF(C1:C8<>4,C1:C8))

entered with ctrl + shift & enter will not consider 4

Regards,

Peo Sjoblom
 
You must log in or register to reply here.

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

Excel VBA 1
Set non-continuous PrintArea via Function / Name 0
SUMPRODUCT formula I think w/ wild card & number vs number as text 8
Specifying comparision criteria with SUMIF() 2
Finding location (or start cell) of highest consecutive values 3
Trying to find additional ranges outside of min, max, and average 2
Is a combination of INDIRECT with INDIRECT.EXT, a component ofmorefunc.xll by Laurent Longre, valid? 1
SUMIF with criteria "<>" & "=" 4

Back
Top