If cell empty delete row

C

Clive

Hi. I posted this message on November 6th
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".

And Jacb Skaria relpied : In cell B2 =IF(COUNTIF(C:C,A2),A2,"")

If this post helps click Yes. Yes it did work. Fantastic!
However, I need to tidy up the spreadsheet.

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

Thanks again
Clive
 

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

compare 2 columns of numbers and place the matched numbers in a 3r 5
Search cell value in same column 3
IF Statement Problem 4
Delete row with empty cell in column 4
Making a cell empty 3
Insert, Delete row and cell 0
Macro that sorts data with blanks at the bottom 1
Hide columns based on row values 2

Top