Finding matching cells

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?
 
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.
 
G

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
 
A

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top