| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculate ranking
Hi,
given the table below A B C D F G 1 Activity Edward Louis Anna Emma Ranking 2 A 5 2 6 2 1 3 B 8 2 1 4 4 4 C 2 6 8 4 1 5 D 5 4 6 7 2 How to calculate the last column, i.e. the ranking of Anna? Thanks! tom |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
calculate ranking
I don't know what happened to column E, but this is the idea.......
In G2, put this and copy down......... =RANK(D2,B2:F2) hth Vaya con Dios, Chuck, CABGx3 "tom ossieur" wrote: Hi, given the table below A B C D F G 1 Activity Edward Louis Anna Emma Ranking 2 A 5 2 6 2 1 3 B 8 2 1 4 4 4 C 2 6 8 4 1 5 D 5 4 6 7 2 How to calculate the last column, i.e. the ranking of Anna? Thanks! tom |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
calculate ranking
It's not clear what you're asking. Need a better explanation.
Biff "tom ossieur" wrote in message ... Hi, given the table below A B C D F G 1 Activity Edward Louis Anna Emma Ranking 2 A 5 2 6 2 1 3 B 8 2 1 4 4 4 C 2 6 8 4 1 5 D 5 4 6 7 2 How to calculate the last column, i.e. the ranking of Anna? Thanks! tom |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ranking problem | Excel Worksheet Functions | |||
| can't get excel to calculate | Excel Worksheet Functions | |||
| any formula to auto calculate 1st-12th is 12 days pls? | Excel Discussion (Misc queries) | |||
| Calculate appears in status bar | Excel Discussion (Misc queries) | |||
| Spreadsheet Won't Calculate | Excel Discussion (Misc queries) | |||
Linear Mode
