Report another column value when a max is found

Remy V

Hello, attached is the sheet im working with. I'd like to report the location name of which has the max value of minutes. What function do I use to do this?

JamesB

@Remy V

This formula will do what you need.

=INDEX(COLLECT(Location:Location, [Total Minutes]:[Total Minutes], MAX([Total Minutes]:[Total Minutes])), 1, 0)