Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Guys, i'm completely stuck on this and hoping you can help. i have 2
columns with emails. i need to compare column B to Column A. if an email that is in column B is also in column A, then i don't need it. but if it's unique to column B (it's not in column A as well) then i need that email. i can't for the life of me figure out how to do this. i was doing an IF function, but it's not working. i was doing this =IF(B2=A1:A443, 'NO', B2). so basically, if the email in cell B2 is found in the range A1 to A443, then type NO, if the email in B2 is NOT found, then give me the email that is in B2. this function is not working though. can you help me out? Thank you Carla |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Have a look at VLOOKUP
More details in morning -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "calberto22" wrote in message ups.com... Guys, i'm completely stuck on this and hoping you can help. i have 2 columns with emails. i need to compare column B to Column A. if an email that is in column B is also in column A, then i don't need it. but if it's unique to column B (it's not in column A as well) then i need that email. i can't for the life of me figure out how to do this. i was doing an IF function, but it's not working. i was doing this =IF(B2=A1:A443, 'NO', B2). so basically, if the email in cell B2 is found in the range A1 to A443, then type NO, if the email in B2 is NOT found, then give me the email that is in B2. this function is not working though. can you help me out? Thank you Carla |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Assuming source data running in cols A and B, from row1 down
In C1: =IF(B1="","",IF(ISNUMBER(MATCH(B1,A:A,0)),"",ROW() )) In D1: =IF(ROW()COUNT(C:C),"",INDEX(B:B,SMALL(C:C,ROW()) )) Select C1:D1, copy down to last row of data in col B. Hide away col C. Col D will return the required results, ie email in col B not found in col A, with all results neatly bunched at the top -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "calberto22" wrote in message ups.com... Guys, i'm completely stuck on this and hoping you can help. i have 2 columns with emails. i need to compare column B to Column A. if an email that is in column B is also in column A, then i don't need it. but if it's unique to column B (it's not in column A as well) then i need that email. i can't for the life of me figure out how to do this. i was doing an IF function, but it's not working. i was doing this =IF(B2=A1:A443, 'NO', B2). so basically, if the email in cell B2 is found in the range A1 to A443, then type NO, if the email in B2 is NOT found, then give me the email that is in B2. this function is not working though. can you help me out? Thank you Carla |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
One way....
Paste this formula into C1 and copy down as far as needed. =IF(ISNA(VLOOKUP(B1,A:A,1,FALSE))=TRUE,B1,"") Rob "calberto22" wrote in message ups.com... Guys, i'm completely stuck on this and hoping you can help. i have 2 columns with emails. i need to compare column B to Column A. if an email that is in column B is also in column A, then i don't need it. but if it's unique to column B (it's not in column A as well) then i need that email. i can't for the life of me figure out how to do this. i was doing an IF function, but it's not working. i was doing this =IF(B2=A1:A443, 'NO', B2). so basically, if the email in cell B2 is found in the range A1 to A443, then type NO, if the email in B2 is NOT found, then give me the email that is in B2. this function is not working though. can you help me out? Thank you Carla |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
comparing two text ranges | Excel Discussion (Misc queries) | |||
comparing ranges/arrays | Excel Worksheet Functions | |||
Comparing ranges: | Excel Discussion (Misc queries) | |||
How to : Comparing Two Ranges | Excel Worksheet Functions | |||
comparing multiple ranges | Excel Discussion (Misc queries) |