help with sorting text in columns to match other columns

R

rkat

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

Miguel Zapico

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.
 
Top