I have a range of data in multiple (10) columns with headers. Headers may read: Name Description Holder Size Length, etc. Some of the data in columns are duplicates. I want to filter only unique record pairs in columns Name and Description, extracting it to a different place in the sheet. Example of data:
Name Description Holder Size Length
.5 DRILL chuck 1/2 8
.5 DRILL collet 1/2 8
.5 REAMER collet 1/2 7
.5 DRILL chuck 1/2 7
etc.
As you will see, entries in rows 1, 2 and 5 have the same Name and Description and may have different Holder, Size or Length. Row 4 has the same Name, but different Description, the rest may be anything.
I want to filter the data, so that I will only get two rows: row 2 (or 3, or 5) and 4, which have unique (.5 DRILL) and (.5 REAMER) combinations. The trick is to pull the rest of the records in rows C, D, ... along (and I do not care which row out of multiple selection I get; for instance, I would be happy to get either of three possible data combination for a result of a unique .5 DRILL pair)
.5 DRILL chuck 1/2 8,
.5 DRILL collet 1/2 8,
.5 DRILL chuck 1/2 7
If I set List Range to include all data, it treats the entries in all rows (including C, D, ...) as unique criteria. If I set List Range to just columns A and B, it does the trick, but I would not get the rest of the entries in columns C, D, ... copied.
Is this posiible at all to do?
Thanks for the help.
Bookmarks