| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pinewood deby sort
I have a Excel workbook that will provide a listing of boys and there total
score (1 for first place, 2 for second place, ... I can manually resort the information to find out who finished first, second, ... But I would rather have Excel do this for me automatically, as shown below, If everyone has the same score everyone finishes in first place. Thanks in advance for your help! Name Score Billy 22 Tommy 22 Peter 25 Paul 24 Johnny 36 Steve 29 Jerry 26 Andy 24 Sam 28 Name Score Place Billy 22 1 Tommy 22 1 Paul 24 2 Andy 24 2 Peter 25 3 Jerry 26 99 Sam 28 99 Steve 29 99 Johnny 36 99 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Select rows and sort based on type | Excel Discussion (Misc queries) | |||
| data sort is not including all columns in sort | Excel Discussion (Misc queries) | |||
| sorting more than 3 keys | Excel Discussion (Misc queries) | |||
| "-" ignored in sort | Excel Discussion (Misc queries) | |||
| HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
Threaded Mode
