Then you can sort Ascending column D
"Erich Becker" wrote in message ...
You can also try this one. Formula in D2






"fruitchunk" wrote in message ...
I would like a formula to see the Top Ten performers, example:

In Column A from A1 down to A100 I have a list of Employees by Name
In Column B from B1 down to B100 I list their employee ID#
In Column C from C1 Down to C100 I have their total amount of sales last month

I would like to see who the top ten employees are without sorting

I can't figure this out, this is how I want to see it
-in Column E from E1 to E2 should list the top ten amounts
-next to the amount in Column F should be their employee ID#

Can you please help?