PC Review


Reply
Thread Tools Rate Thread

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

 
 
mel1936
Guest
Posts: n/a
 
      22nd Nov 2009
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?
 
Reply With Quote
 
 
 
 
JLatham
Guest
Posts: n/a
 
      22nd Nov 2009
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?

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Fetching & Inserting Data into a column of TEXT Data type in SQL server 2000 Using ASP.NET Bhavesh Microsoft ASP .NET 5 18th Jul 2007 08:39 AM
Fetching & Inserting Data into a column of TEXT Data type in SQL server 2000 Using ASP.NET Bhavesh Microsoft ASP .NET 1 17th Jul 2007 10:05 AM
Sort a column (specifically email data) by end of text, not beginn =?Utf-8?B?WmlwIGNvZGUgaGVscA==?= Microsoft Excel Worksheet Functions 4 14th Oct 2005 07:13 PM
How can I reference data or text within a text box to a cell in Ex =?Utf-8?B?QkI=?= Microsoft Excel Misc 2 25th Jan 2005 07:55 PM
Copy the text data from the column of an excel sheet into a text file . Sharbat Microsoft Excel Misc 2 21st Mar 2004 12:28 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:09 AM.