Highlighting or otherwise identifying top salesperson

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dataman - 29 Mar 2006 22:31 GMT

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?

Reply to this Message

Don Guillett - 29 Mar 2006 23:32 GMT

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)

Signature

Don Guillett
SalesAid Software
dguillett1@austin.rr.com

> On a summary worksheet the YTD statistics are copied from the
> salespersons detail worksheets. From that date we can identify the top
[quoted text clipped - 5 lines]
> place the name in a cell at the bottom of the worksheet based on the
> (Column B) highest value in the sales column?

Reply to this Message

dataman - 30 Mar 2006 00:09 GMT

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?

Reply to this Message