Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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? |