Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with automatically sorting data
I have a list of golfers names in A1-A6 (A1=Smith, A2=Jones,A3=Johnson,
A4=Walker, A5=Martin and A6=Peach. In column B next to their names are each golfer's score (B1=75, B2=78, B3=80, B4=84, B5=85, B6=88). In column C (C1-C6) I want the golfers names to appear in order (C1-C6) based on their scores in column B. So if I changed the score in B4 to "72", I want his name to move from C4 to C1 and the names that were in C1, C2 and C3 to move down 1 spot each in the C Column. I also need this to work if two or more of the golfers have the same score. For example...if three golfers all tie for the best score with a 70, I need them to appear in C1-C3 and the rest of the golfers to appear in order in C4-C6 respectively. Is this possible? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with automatically sorting data
Hi,
Please read up on the RANK() worksheet function in the Help menu -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Jim48762" wrote in message ... I have a list of golfers names in A1-A6 (A1=Smith, A2=Jones,A3=Johnson, A4=Walker, A5=Martin and A6=Peach. In column B next to their names are each golfer's score (B1=75, B2=78, B3=80, B4=84, B5=85, B6=88). In column C (C1-C6) I want the golfers names to appear in order (C1-C6) based on their scores in column B. So if I changed the score in B4 to "72", I want his name to move from C4 to C1 and the names that were in C1, C2 and C3 to move down 1 spot each in the C Column. I also need this to work if two or more of the golfers have the same score. For example...if three golfers all tie for the best score with a 70, I need them to appear in C1-C3 and the rest of the golfers to appear in order in C4-C6 respectively. Is this possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data sorting automatically? | Excel Worksheet Functions | |||
Sorting Data Automatically | Excel Worksheet Functions | |||
Automatically sorting data | Excel Discussion (Misc queries) | |||
Sorting data automatically | Excel Worksheet Functions | |||
Sorting Data Automatically | Excel Discussion (Misc queries) |