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

Guest

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.
 

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

Similar Threads

Matching cells 2
Having Blank Cells, etc. ? 1
Reference Formula Help 1
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Popups to look up on two variable columns 1
Return value of non matches in columns 4
Summing rows using formulas with variables 1
match a word in a cell and copy anoher cell in the same row 1

Top