Hi,
I have the following sample data:
Column1 Column2
----------------------------
11111 $99999
22222 $88888
33333 $77777
44444 $66666
55555 $55555
11111 $44444
11111 $33333
55555 $22222
Column 1 contains data that have duplicate data
Column 2 is sorted from Largest to Smallest
I want to re-sort the list so that I get this:
Column1 Column2
----------------------------
11111 $99999
11111 $44444
11111 $33333
22222 $88888
33333 $77777
44444 $66666
55555 $55555
55555 $22222
I need to keep Column 2 as a primary sort, but if any of the entries from Column 1 are identical to the first row (11111 $99999) I want to list them right below it.
I hope my explanation makes sense.
Please tell me what to do. Thank you.
Bookmarks