List combinations of a range
I forgot to mention, without a macro. Thx
"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
|