What I'm trying to do is this.

I have 3 columns: A , B , C. A is master key column that B needs to be
sorted by and B has duplicates. Every value in B has an unique string
in column C.

EXAMPLE:


A B C
cp-ra-2 cp-ra-2 cph-3
cp-ra-3 cp-ra-3 cph-33
cp-ha-4 cp-m-3 cph-345
cp-za-3 cp-ha-4 cph-53
cp-df-3 cp-ha-4 cph-32

After resorting the output should be this

cp-ra-2 cph-3
cp-ra-3 cph-33
cp-ha-4 cph-53
cp-ha-4 cp-32



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/