Locate and Match Data

K

kukarooza

Thanks up front to anyone who can help me. My problem is that I hav
two columns of data, columns A and B. Each column has a given set o
numbers in it, approximately 3000 rows deep. I need to run a progra
that tells me what numbers in column B match up to those in column A.
The matches should be automatically listed in column C.

Thanks!
:cool
 
M

Myrna Larson

No need for a macro for this. In column C, put this formula:

=COUNTIF($A$1:$A$3000,B1)

and copy down. Adjust references if necessary.

Then AutoFilter on this column to display rows with a value >0 in column C.
Once you've filtered, Copy the visible data from column B, paste in column D.
Then turn off the filter and delete column C.
 
Top