include in new column only if present in both columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have two list of names of 500 to 1000 in size that are in two different
columns. I would like to generate a new column with names that are only
present in both list of names. help. thanks
 
This probably isn't exactly what you want but your certainly welcome to try it.

If your first list is in column A and your second is in B1:B1000, in C1 you
could put:

=IF(ISERROR(VLOOKUP(A1,$B$1:$B$1000,1,0)),"",A1)

Then copy the formula down thru the last row of A column data.

You will end up with blanks in column C where a value from column A is not
in column B. Also if a given value can exist more than once in column A you
could have duplicates in column C. If there are no duplicates, at worst
you'd just need to copy column C over to a blank sheet and sort it to get rid
of the blanks

Will
 
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

Excel Comparing two columns 1
Comparing Lists of text using colors or by other means 1
VBA - retrieve data on last create named range from previous inserted named range 0
Vlookup ? 2
COUNTIF not including something in both columns 2
How to filter Unique values from Duplicates 6
Conditional validation with only two columns 7
Multiples conditions in an array 3

Back
Top