hi - is there a formula that matches text in different 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=570581

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

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"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=570581

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

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

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---