compare 2 columns of numbers and place the matched numbers in a 3r

C

Clive

Hi.
I am a newcomer and I need your help.
I need a formula that can compare a column of numbers (Column A) "LabMaster"
with a 2nd column of numbers (Column C) "ScanFiles" and copy each matched
number to Column B, adjacent to its match in Column A "Labmaster.
(Possibly 4,000 numbers in "Labmaster".

Thanks
Clive
 
C

Clive

Jacob you are truly fantastic!!!
Thank you so very much!
I am a very happy man!

Clive
 
C

Clive

Is it possible to add to this formula?
At the moment, when executed, it leaves empty unmatched cells in column B -
a large number.
Can the formula be extended to: if cell in column B is empty, delete row?

Thanks again
Clive
 
J

Jacob Skaria

Sorry, you cannot do any deletions using formulas. You will need to use
amacro to do this...

If this post helps click Yes
 

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

If cell empty delete row 1
Setting column width in a table with a macro is not working 0
How can the font and size of (all) citation numbers be altered? 1
How to count the numbers in a Word document? 0
Copy pair of columns 3
Creating sequential numbers plus a letter 4
Comparing numbers 1
Matching data in columns 1

Top