An array of data placed in four columns may contain matching rows. For instance, invoking Macro1 in the attached example2.xlsm leads to a table in Sheet3 with 3 matching rows of one kind and 2 matching rows of another kind. I'd like first to have a macro recognize that there are matching rows at all and then show which these exact rows are and what is their ratio with respect to the overall number of rows. I tried using the advanced filter but the unique rows always included one of the matching rows. Thanks in advance.