Matching cells
 

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

Matching cells
 

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.

"GARY" wrote:

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

Matching cells
 

Don't I need to copy and paste the formula from C1 to C9800?