Can I sort text data by reference to text data in another column?

  • Thread starter Thread starter mel1936
  • Start date Start date
M

mel1936

I have imported text data (e-mail addresses) into a worksheet that also has a
column of text data (also e-mail addresses), many of which, but not all, are
the same as the imported text data. I wish to sort the imported text data
into the rows of the matching original text data. How do I do that?
 
The basic process would be to get all email addresses into a single column.

Then select ALL columns to be sorted and use Data --> Sort and choose the
column with the email addresses as the column to base the sort on.

Duplicate email addresses will end up on adjacent rows.
 
Back
Top