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