n my spread sheet i have 2 columns one been the name of the person other been number tickets open.
Name 2
Name2 4
Name3 3
I want a formula that can tell me the max number in column B and display who has the highest number by getting the information from A column. so the end result in would be simply Name2