Finding matching cells
 

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?

Finding matching cells
 

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.

On Jan 28, 1:47*pm, gcotterl wrote:
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?

Finding matching cells
 

On Jan 28, 6:47*am, AB wrote:
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

Finding matching cells
 

On Jan 28, 3:19*pm, gcotterl wrote:
On Jan 28, 6:47*am, AB wrote:

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

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.

Finding matching cells
 

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.