Sort and match?

[Johnf42]

Is it possible to sort and match two columns?

For example...

Pre-sort

column 1 column 2
4 5
2
5 1
1 3
3

After sort

column 1 column 2
1 1
2
3 3
4
5 5


Each column is sorted and matches the other column.

[zbor]

something like this:

Book1.xls

[Johnf42]

Yes, exactly. I'll try it out and let you know how it works.

Thanks!

[DonkeyOte]

similar question here: http://www.excelforum.com/excel-gene...9131-sort.html

(in case you want to do something with the unique values in Col 1 - ie placing in blank spaces in Col 2)