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

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?

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

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.

"mel1936" wrote:

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?