Compare two ranges of data and give unique values in two different columns ignoring blanks

Hi all ,

I have huge feeds of algorithm test cases for a tool .. My job is to identify the blocks where there is difference in the algorithm output and the input feed ..

-----------------------------------------------------------------------------------




Column A contains the feed data and few blank cells

example

BOL CWB 8690-6086(SIZE/COLOR)(
PAEDABNMNBLLOAJP-2948
PAEDIBEKNILLOAJP-2952
PAEDABKONDLLOAJP-2949
PAEDIBNMNGLLOAJP-2950
PAEDABIGGOLKOAJP-2947

)


BOL CWB 8647-1000(SIZE/COLOR)(
PAEDIBAKPJLJOAJP-2944
PAEDABFNPLLJOAJP-2945
PAEDIBFDCBLIOAJP-2942
PAEDABNAPGLJOAJP-2943
PAEDABNAPGLJOAJP-Extra feed


)

Variaton theme : size

--------------------------------------------------------------------------------------

Column B contains the Algorithm data


PAEDABKONDLLOAJP-2949
PAEDIBNMNGLLOAJP-2950

PAEDABIGGOLKOAJP-2947
PAEDIBAKPJLJOAJP-2944
PAEDABFNPLLJOAJP-extra algorithm data

PAEDABNMNBLLOAJP-2948
PAEDIBEKNILLOAJP-2952

Detected Theme : Size


-----------------------------------------------------------------------------------------



I want a macro to do the following .

Compare the entries in column A with entries in column B . Ignore blank cells and Cells with "(" , ")" and "theme"


Output in column E will be count of entries in A
output in column F will be count of entries in B
Output in column G will be the values in A which are not in B
Output in column H will be values in B which are not in A

------------------------------------------------------------------------------------

Expected outputs for the example are ..

Column E

10

Column F

7

Column G

PAEDABNAPGLJOAJP-Extra feed
PAEDABFNPLLJOAJP-2945
PAEDIBFDCBLIOAJP-2942


Column H

PAEDABFNPLLJOAJP-extra algorithm data


Sample data attached with desired output example

Autovar.xlsx




--------------------------------------------------------------------------------


It will be helpful if someone can write the code to work on ranges rather than the whole column . Thanks in advance.

See if this is how you wanted

Please Login or Register  to view this content.

I solved the borders part too .. Ive pretty much changed what i needed .. thanks a lot ... you are real savior .. Arigato gosaimus ..