Assuming you want the unique combinations in a set of columns, it
sounds like a job for
Data Filter Advanced Filter Copy to another location Select the
columns concerned as the source range Unique values only.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup