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