Matching cells

G

GARY

How can I determine which cells in Column A contain the same contents
as cells in Column B?
(Column has 9,800 rows; Column B contains 3,600 rows).
 
N

Naveen

Please try this ...

-> Paste it in C1
=VLOOKUP(A1,$B$1:$B$3600,1,0)

-> Copy and paste C1 to C2 to C3600

if you get "#N/A", that is not available in Column B, or else you will get
same as Column A.

Please rate me.
 
Top