Comparing ranges?

  • Thread starter Thread starter calberto22
  • Start date Start date
C

calberto22

Guys, i'm completely stuck on this and hoping you can help. i have 2
columns with names. i need to compare column B to Column A. if a name
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 name. 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 name in B2 is found
in the range A1 to A443, then type NO, if the name in B2 is NOT found,
then give me the name that is in B2. this function is not working
though. can you help me out?

Thank you

Carla
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Comparing 2 ranges? 3
Help needed to writing a macro to put the year in column B of a tableusing Table nomenclature & the 7
Find string from column A in Range("B2:F7") list the header of that column/s 5
Paste in column B using Last row of either column B, C or D. 10
Array VLOOKUP lookup_Value does not increment 3
Macro for Creating Word Document!! 5
How to hide password? 1
Clear a "moving" range offset from Target 31

Back
Top