I need to do this automatically if possible; the results will be linked to
another worksheet.

"Ron Coderre" wrote:

Try this:

With your list is in A1:B100, with A1 and B1 as the Heading: eg MyCol_A,
MyCol_B, respectively.

D1: MyCol_A (the same col heading as A1)
E1: MyCol_B (the same col heading as B1)

Select your list (A1:B100)
<Data<Filter<Advanced Filter
List Range: (already selected $A$1:$B$100)
Check: Copy to another location
Copy to: $D$1:$E$1 (which contains the col headings)
Check: Unique Records
Click the [OK] button

That will create a list, under D1:E1, of the unique combinations in A:B

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"Steve-in-austin" wrote:

I need a formula to find the actual combinations in a 2-column, 50-row range.
Both columns are constrained to 10 text characters if that makes it easier.
e.g.
Data: (may be in random order)
A A
A B
B A
B B
B C
B C
B B
J A
J A

Looking for this result:
A A
A B
B A
B B
B C
J A

Thanks