Vinding name based on location and maximum value

[RolandK]

I got stuck on the formula to find the value of a cell, based on two conditions.
column A has location, column J has number of days. I now want to find the name with the highest number of days for each different location from column S.(rows in between do hold data, but are not relevant for thuis purpose) Added problem is that I can't predict the Total number of rows to look in.
I tried a dozen different was, but can't get it right. Please help!

 

[SaraT83]

Hi,

Hi

I have a feeling there might be something missing in your description of what you require, but the below formula will tell you which location has the highest value in the corresponding Row in Column J.

=INDEX(A:A,MATCH(MAX(J:J),J:J,0))

Sara

 

[RolandK]

Hi Sara,

your feeling is right. Column S holds names. So i want to find the name that goes with the highest value for each location.
i have no access to the file until monday, but I think your formula sets me on the right path!

thanks for your reply, if my further info has given you an even better idea than please let me know

RolandK