A1:A100
// list of names
B1:B100
// numbers per name
C1 = MAX(B1:B100)
// the biggest number in the number array
D1 = Index(A1:A100, Match(C1, B1:B100, 0) )
// Name of FIRST person in list with max number (if two people have equally big numbers the second will not be listed)
Bookmarks