My work has a "Shame" counter. Whoever gains the most shames in a week has to buy the round for the office the following week. Currently, we use
=INDEX(B5:B14,MATCH(MAX(C5:C14),C5:C14,FALSE),)
to choose the name with the highest number against it. However in the event of a tie, the result defaults to the name nearest the top of the table, rather than picking at random.
I've tried using the RANDBETWEEN() function, however can't seem to get it to pick the max value at random.
The counter itself can be found here: Shame Counter
Please can someone have a look and advise?
Aucun commentaire:
Enregistrer un commentaire