I have a list of scores and need to find the maximum value but also identify any duplicates of that max value. In other words, a top score wins and there may be equal top scores; e.g.

Ali 22
Bert 24
Chas 21
Dave 22
Eric 24

I need the two values of 24 to be identified and then stored along with Chas & Eric in other cells.

Thanks for any help, happy to use VBA if it’s easier.

I’ve tried Max & Large functions which shows the maximum value & I can identify of there’s a draw with: =IF(COUNTIF(G8:G11,G12)>1,”Draw”,”No Draw”) but I need these two blended somehow into one