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

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

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

Maybe this...

=IF(COUNTIF(C:C,A2),A2,"")

Copy down as needed

--
Biff
Microsoft Excel MVP


"Clive" wrote in message
...
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

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

In cell B2

=IF(COUNTIF(C:C,A2),A2,"")

If this post helps click Yes
---------------
Jacob Skaria


"Clive" wrote:

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

compare 2 columns of numbers and place the matched numbers in
 

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

Clive

"Jacob Skaria" wrote:

In cell B2

=IF(COUNTIF(C:C,A2),A2,"")

If this post helps click Yes
---------------
Jacob Skaria


"Clive" wrote:

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

compare 2 columns of numbers and place the matched numbers in
 

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



"Jacob Skaria" wrote:

In cell B2

=IF(COUNTIF(C:C,A2),A2,"")

If this post helps click Yes
---------------
Jacob Skaria


"Clive" wrote:

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

compare 2 columns of numbers and place the matched numbers in
 

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

If this post helps click Yes
---------------
Jacob Skaria


"Clive" wrote:

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



"Jacob Skaria" wrote:

In cell B2

=IF(COUNTIF(C:C,A2),A2,"")

If this post helps click Yes
---------------
Jacob Skaria


"Clive" wrote:

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