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
|