Hi,
I have 4 columns [A CODE], [B TAG],[C CUSTOMER],[D AMOUNT] this are all duplicates in the sense of columns A,B,C I want them to group. if all 3 columns matches to more of them then generate report on next sheet with consolidated 4th column of Amount, and duplicates counts occurred