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

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

JLatham

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top