79405572

Date: 2025-02-01 19:38:39
Score: 3.5
Natty:
Report link

I have used the below formula

index(B39:B58, MATCH(MAX(A39:A58), A39:A58, 0)) to tell me how the name in range B39:B58 with the highest value in range A39:A58. However, since this won't return values that are equal, who would I add a COUNTIF formula to this to return multiple names of they have the same value?

Reasons:
  • No code block (0.5):
  • Ends in question mark (2):
  • Low reputation (1):
Posted by: Nathalie Scott