hi - is there a formula that matches text in different columns?

R

rkat

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
 
M

Max

One way to compare and produce the results that you want ..

Assuming data in cols E and F is from row1 down
Put in G1:
=IF(ISNUMBER(MATCH(E1,F:F,0)),E1,"")
Copy G1 down to E1000 (the last row of data in col E)
Col G returns the required results

If desired, copy col G and overwrite col F
with a paste special as values, then clean up by deleting col G
 
M

Max

Should you have email in col F which is not found in col E,
then better to withhold this action ..
If desired, copy col G and overwrite col F
with a paste special as values, then clean up by deleting col G
Click to expand...

To check & retrieve any email in col F which is not found in col E

Put in I1:
=IF(F1="","",IF(ISNUMBER(MATCH(F1,E:E,0)),"",ROW()))

Put in J1:
=IF(ROW(A1)>COUNT(I:I),"",INDEX(F:F,MATCH(SMALL(I:I,ROW(A1)),I:I,0)))

Select I1:J1, copy down to the last row of data in col F

Col J will return email in col F which is not found in col E,
with all results neatly bunched at the top
 
Top