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.
Bookmarks