Automatic sort
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 |
All times are GMT +1. The time now is 06:23 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com