How to compare two colums in Excel and find the differennce also

[Haimi-32]

I have two columns, 1 with 3800 entries and 2 with 1500 entries. I want to find the entries which are in column 1 but not in column 2.

[DanielaA]

I would d use a formula like this in a helper column:

=isnumber(match(a1,sheet2!a:a,0))
and drag down.

True means that a1 appears in sheet2, column A.

[GALIENA]

Refer to the following link. The link provides in detail information on the same. Hope this will help.

How to compare data in two columns to find duplicates in Excel

[QUENBY]

Perhaps the question has been asked already but nothing has really worked. I have a problem with Excel as follows. I have a parts list in column A (3224 pieces). I came up a parts list in column B (3423 pieces). Now I need a formula or macro in the column C which parts of the outputs in column B or more in it are in column A are not present. I've tried a Macro but it has not worked very well and there was the problem since the parts are mixed up and scan it or check must be the whole column a and then b and then compare what did not work.

[Hollyn]

The answer is VLOOKUP. This function can shower the first column of a table can be searched for a keyword. Lookup worksheet returns N if it is not the search term. You write the formula in column C - which looks something like this:= VLOOKUP (B1, $ A $ 1: $ A $ 3224, 1, False). You will receive a return value of the Item no. (Which I hope is unique It could not otherwise) if the search term was found in column B. I do not know how much and 'more practical comparison' of 2 columns at a time, with the 'set date, compare columns 3 would be to create additional columns 6 and 4 are 12 additional columns compare .