help with sorting text in columns to match other columns
 

Hi,
I have two columns of email addresses, say 1000 in Column E and 500 in
Column F. I would like to sort Column F so that each individual email
address in column F is in the same row as its matching email in Column
E. Is there an easy way to do this? Thanks


--
rkat
------------------------------------------------------------------------
rkat's Profile: http://www.excelforum.com/member.php...o&userid=37366
View this thread: http://www.excelforum.com/showthread...hreadid=570576

help with sorting text in columns to match other columns
 

One thing you can do is to use an additional column with this formula:
=IF(COUNTIF($F$1:$B$500,E1)0,E1,"")
And copy it across the column to match the column E. The emails that are in
the F column will be on the same line in column F, and it will be blank in
the others.
If you need it on column F, you can copy/paste values from that extra column
to column F.

Hope this helps,
Miguel.

"rkat" wrote:


Hi,
I have two columns of email addresses, say 1000 in Column E and 500 in
Column F. I would like to sort Column F so that each individual email
address in column F is in the same row as its matching email in Column
E. Is there an easy way to do this? Thanks


--
rkat
------------------------------------------------------------------------
rkat's Profile: http://www.excelforum.com/member.php...o&userid=37366
View this thread: http://www.excelforum.com/showthread...hreadid=570576