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