I am using Excel 2013.
I have two sheets, 1st with the raw data, 2nd for a summary page.
Raw Data Page:
Column A List of locations
Column B Numbers
In Row 1 column B I have a MAX statement which gives me my MAX number.

Summary Page:
I want to be able to list the location that has the MAX number with the number next to it.

Any help would be greatly appreciated.

-Dale