Finding matching cells

  • Thread starter Thread starter gcotterl
  • Start date Start date
G

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?
 
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.
 
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.
Click to expand...



I want a formula

Highlight every cell in Col A that matches one or more cells in Col B
 
I want a formula

Highlight every cell in Col A that matches one or more cells in Col B
Click to expand...

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.
 
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.
 
Back
Top