F
fruitchunk
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?
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?