Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

Column comparation in different datasheet [Solved/Closed]

Report
-
 Ruben -
Hello,



Hello,
I have one excel column A in datasheet 1 which has a list of names. In Column
A of datasheet 2 I have a much longer list of names. Some of the names are in both columns from both sheets. I am looking for a formula that will produce in column A of datasheet 3 the names that appear only in sheet 2.
Thanks for your help!!!

1 reply

Answer 1 / 1
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
 797
many ways of doing it. see are you happy with this

in sheet2 in B2 (row one is column headings in both sheets)

type this formula

=IF(ISERROR(A2=Sheet1!$A$2:$A$10),"NO","fYES")
while writing the formula take the cursor to sheet1 and draw it whole data range in column A so that
$A$2:$A$10
will be correct range.
convert these references to absolute ref
copy B2 down
easy way is
take the cursor to right bottom B2 when cursor changes into bold plus sigb
click that plus sign
now filter sheet according to column B criteria being "NO"
in the filtered data copy column A and paste it in sheet 3
Report

Thank you a lot! you solved my problem. Best regards!
Ask a question

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!