Locate and Match Data

[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

 

[JulieD]

Hi

check out
http://www.cpearson.com/excel/duplicat.htm

for ideas and methods on working with duplicates

Cheers
JulieD

 

[Frank Kabel]

Hi
see:
http://www.cpearson.com/excel/duplicat.htm

 

[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.