Finding matching cells

[gcotterl]

Col A has 3,000 rows
Col B has 57,350 rows.

How do I find the cells in Col B whose contents match those in Col A?

 

[AB]

if you indeed want help/advise here - you might wanna be a bit more
specific. Do you want a code or formula or manual solution?
How do you want the matching cells to be drawn to your attention - get
them selected, get them highlighted (but then, what if column a has
1000 different values that mathc 30000 cells in col B?).
Need to be more specific.

 

[gcotterl]

if you indeed want help/advise here - you might wanna be a bit more
specific. Do you want a code or formula or manual solution?
How do you want the matching cells to be drawn to your attention - get
them selected, get them highlighted (but then, what if column a has
1000 different values that mathc 30000 cells in col B?).
Need to be more specific.

I want a formula

Highlight every cell in Col A that matches one or more cells in Col B

 

[AB]

I want a formula

Highlight every cell in Col A that matches one or more cells in Col B

Apply conditional formatting to the cells of your interest in Col A.
Conditional formatting can be found dirrenetly depending on which
MsOffice you use (2003 (Format menu) vs 2007-2010 (find somewhere on
the ribbon)).
The conditional formatting criteria would be a formula:
=COUNTIF($B$1:$B$57350,A1)
Bear in mind that this might be quite a slow process as for the file
there will be 3,000 calcs to make and each calc will need to search
57K rows.

 

[Javed]

Or can use pivot table.This will even show the cells in Col B whose
contents match those in Col A
the cells
in Col A whose contents match those in Col B

Pls mail me the file if you feel.