Steve,

Try this

=MATCH(B2,LARGE(IF($C$2:$C$13=C2,$B$2:$B$13),ROW(I NDIRECT("1:"&COUNTIF($C$2:
$C$13,C2)))),0)

it is an array formula, so commit with Ctrl-Shift-Enter

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Steve DeBruin" wrote in message
...
How can I get excel to not only do a ranking using the sales of all the
employees, but also a rank by region as well? The real spreadsheet is
much
larger and would take a lot of time to rank by hand. I would like to have
a
formula do this, not sorting the list and then filling down. Thanks.

Steve