Removing Duplicate Data Sets

Hi all,

I'm trying to create a macro that runs through data sets and removes duplicate entries. I have been sucessful with removing single entries but I can't figure out how to compare ranges and remove those that are the same. I have attached a file. Any help would be greatly appreciated.

1. Are the "ranges" always in the same places on the sheet ?
2. Is the order of entries in the "ranges" (to be compared) always the same ?

The ranges will be in the same place. The order of the ranges may change. If possible I only want exact duplicates to be removed.

Originally Posted by fullmetalchrono

... The order of the ranges may change ...

... order of entries (Bananas, Pears, Apples, etc.) in the "ranges" ... not order of the ranges ...
so .. Is the order of entries (Bananas, Pears, Apples, etc.) in the ranges always the same ?

Sorry. I mistyped. I meant that the order of entries may change. I just want the macro to remove completely identical ranges of data, not ones that are in a different order.

How big/large will the individual (compared) ranges be, how many rows ?

I would say a maximum of 20.

Try:

Please Login or Register  to view this content.

Thanks. That works really well. How could I change the results destination here? Say for example further down?

The result row number ==> Const rsltRow = 10

Is there any way I could get the tables to display vertically rather than horizontally?

Probably 'yes' - show an example of data layout after transposition.

Something like this.

Different method used.
Eliminate the duplicate when both column A & B are identical.

Please Login or Register  to view this content.

Originally Posted by fullmetalchrono

... to display vertically ...

E.g.

Please Login or Register  to view this content.