Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I would like to sort automatically and not manually a spreadsheet. Columns A
and B is my data and by using Large command I was able to produce Column C. The problem is how to sort Col. A. Please note that there are repeated values in Col B. I tried by using lookup but since there are duplicated values the number 19 is only related with name 4 (disregarding name 10). I also tried match command to get the row # in the range, Col D, and again 19 in row 10 is omitted. A B C D name 1 19 289 5 name 2 9 125 11 name 3 4 93 7 name 4 10 79 9 name 5 289 56 8 name 6 9 23 12 name 7 93 19 1 name 8 56 19 1 name 9 79 10 4 name 10 19 9 2 name 11 125 9 2 name 12 23 4 3 This is the result I'm looking for name 5 289 name 11 125 name 7 93 name 9 79 name 8 56 name 12 23 name 1 19 name 10 19 name 4 10 name 2 9 name 6 9 name 3 4 Could anybody help??? Thank you -- Alex |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Automatic Sort for variable Ranges | Excel Worksheet Functions | |||
Automatic League Sort | Excel Worksheet Functions | |||
Automatic Sort | Excel Discussion (Misc queries) | |||
Automatic Sort with VLOOKUP/LARGE Functions | Excel Worksheet Functions | |||
Automatic Page Sort | Excel Worksheet Functions |