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?
|