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