| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to rate perfomers on a scale from 1-5
I would like a formula to Rank performers from 1-5, 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 rank each employee on a scale from 1-5 (5 is the highest) based on their performance. ( i.e. The top 20 should get a 5) I can't figure this out, Can you please help? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using "if" function to translate 100 scale into 4.0 scale | Excel Worksheet Functions | |||
| How to draw chart: log scale on X axis, natural scale on y axis? | Charts and Charting in Excel | |||
| Prime rate/Liber rate into sheet automatically? | Excel Discussion (Misc queries) | |||
| Real RATE of return using =RATE illusive, inflation adjusted inflo | Excel Worksheet Functions | |||
| APR - Annual Percentage Rate to Actual Interest Rate | Excel Worksheet Functions | |||
Threaded Mode
