Comparing two columns of numbers for differences

R

Rescueme

I am working with Excel 97 and have two columns A and B. Column A has 2016
rows of numbers in the column. Column B has 1994 rows of numbers (72 less).
I need an easy way to extract all the numbers in column A that are not in
Column B. The majority of the numbers are in both columns but 72 are only
in Column A.

Help Appreciated.
Karen
(e-mail address removed)
 
A

A.W.J. Ales

Karen,

I'm not sure whether this will work for you.
If however your numbers in column A are unique (in column A) and if the same
applies to the numbers in column B this might help.

Assuming your numbers are in A1:A2016 and in B1:B1994, put in C1 the formula
IF(ISNA(VLOOKUP(A1,$B$1:$B$1994,1,1)),1,0) and copy this formula down to
C2016.

Depending on whether there is a copy of the number in the A column in the B
column you now get either a 0 or a 1 in column C.

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 
A

A.W.J. Ales

Oops,

Formula should be : IF(ISNA(VLOOKUP(A1,$B$1:$B$1994,1,0)),1,0)

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 

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

Setting column width in a table with a macro is not working 0
Track Changes change in display 0
Two columns followed by single page-width column on same page 0
Two columns : Continuous two columns vs Parallel two Column 1
Copy addition formula of non-consecutive horizontal cells 2
Comparing numbers 1
How can the font and size of (all) citation numbers be altered? 1
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0

Top