jeudi 16 juin 2016

MODE IFS in excel - applying criteria to MODE function and excluding a number from the series

I am using MODE IF in Excel, which seems to work fine, but I need it to exclude from the MODE all number 2's.

The Formula I am using is as follows:

=IFERROR(MODE(IF($I:$I=I4,$K:$K)),K4)

entered with Ctrl+Shift for an array formula.

The IFERROR bit is there for when there is only one occurrence of a number.

Could anyone please tell me how to develop this formula so that, where the result would normally be a "2", that it finds the next highest occurring number instead?

Many thanks Rich

Aucun commentaire:

Enregistrer un commentaire