MrExcel Publishing
Your One Stop for Excel Tips & Solutions

sort "b" and "a" on same row


Posted by gary on October 19, 2001 11:11 AM

is there a formula in excel to take 2 columns of names(some unique some duplicates) and sort columb "b" so the duplicates are in the same row as "a" and the rest start after the dups?


Posted by Barrie Davidson on October 19, 2001 12:42 PM

Gary, how about putting the following formula in column C and then perform your sort on that column?

=A1&B1

Regards,
BarrieBarrie Davidson