Highlighting or otherwise identifying top salesperson

D

dataman

On a summary worksheet the YTD statistics are copied from the
salespersons detail worksheets. From that date we can identify the top
salesperson weekly.

I have figured out how to find ther highest value in the sales column.

How can I either highlight the (Column A) salepersons name (cell) or
place the name in a cell at the bottom of the worksheet based on the
(Column B) highest value in the sales column?
 
D

Don Guillett

you can use match to find the max row and then use that with an index
function.

=INDEX(a:b,MATCH(MAX(b:b),b:b),1)
 
D

dataman

Wow thats cool! Since I also have a total line it gives me the word
Total.
I added the limits:
=INDEX(A:B,MATCH(MAX(B5:B16),B:B),1)
and it works better.
Is that right or do I need the min and max in the second B:B also?
 
Top