Need to delete the empty line

**hisham_a_j** · 05-28-2012, 02:45 AM

Hi, I get data1 with an empty line between them, and I want to match them to data2 without space between lines, so should I remove the sapce betwenn lines first (I don't know how) and then match them to data2 (I also don't know how to match them except of ex: B1=D1)

Thank you.

**TMS** · 05-28-2012, 02:52 AM

You could delete the empty lines using Autofilter. Filter one of the columns on blank, select the visible rows and delete them.

With regard to matching them, you could use VLOOKUP if you want to return information or just use COUNTIF if you only need to know if there is a match

Regards, TMS

**hisham_a_j** · 05-28-2012, 04:49 AM

Thanks

I appreciate your help

**TMS** · 05-28-2012, 05:22 AM

You don't need to get rid of the blank rows if you don't want/need to.

If the values you are comparing are in column A in each sheet, then this will indicate Match/No Match

=IF(A1="","",IF(COUNTIF(Data2!A:A,A1)>0,"Match","No Match")) and drag down.

It will work regardless of whether there are blank rows or not.

Regards, TMS