In a formula MATCH a maximun value, how to alert about a tie (repated max value)?

[nautilia]

I have this formula:
=INDEX($B$1:$G$1;MATCH(MAX(B2:G2);B2:G2;0))

It looks for the maximum value in a row (all votes from a polling station) and returns the index (header of the maximum value column = name of the most voted party).

In case there were 2 or more repeated maximum values in a range/row, what can I add to the formula to receive a warning or print the 2 maximum values?

[Sam Capricci]

how about this... =IF(COUNTIF(B2:G2;MAX(B2:G2))>1;"warning";INDEX($B$1:$G$1;MATCH(MAX(B2:G2);B2:G2;0)))
(I think I changed all the commas to semicolons for your settings.)

[FlameRetired]

Try array entering this in cell A1 or other and fill down until you get blanks. You will need to change the "," comma argument separators to ";" for your regional settings.

If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.

Please Login or Register  to view this content.

[nautilia]

Thank you both for your replies. They've been very useful to solve my problem
(the first one is OK to check for repeated values; the 2nd has been trickier for me, as I think I've not converted correctly the formula to my regional configuration (and my old Mac excel.)

[FlameRetired]

RE the second one:

Please try this. I believe it is correct though I can not test it at my end.

Please Login or Register  to view this content.