software

I have a worksheet that has salespeople's names in column B and sales totals
in column AJ. Obviously these totals change over time. I would like to had
a formula that checks for the largest sales number (I got the MAX part) and
pulls the name in column B. Basically I'd like a section where I can have
quot;Salesperson of the month:quot; and the output. I do have data in column A and
in various more columns after AJ that I would not like to move around.

=INDEX(B2:B50,MATCH(MAX(AJ2:AJ50),AJ2:AJ50,0))

adapt to fit your ranges, will return name from B2:B50 with max value in
AJ2:AJ50

--
Regards,

Peo Sjoblom

(No private emails please)quot;Ironman273quot; gt; wrote in message
...
gt;I have a worksheet that has salespeople's names in column B and sales
gt;totals
gt; in column AJ. Obviously these totals change over time. I would like to
gt; had
gt; a formula that checks for the largest sales number (I got the MAX part)
gt; and
gt; pulls the name in column B. Basically I'd like a section where I can have
gt; quot;Salesperson of the month:quot; and the output. I do have data in column A
gt; and
gt; in various more columns after AJ that I would not like to move around.