Unique combinations

[nlbertram]

Hello---

Here is an example of what I am trying to do.

I would like to find every unique combination of "Role" as it applies to "Number".


For instance, the 3 unique combinations of "Role" in this example would be:

-- ABC, DEF, GHI (this combination applies to 100019 & 558990)
-- ABC (this single value combination applies to 704561)
-- ABC, DEF (this combination applies to 334567)


Row ID Number Role Points
1 100019 ABC 123
2 100019 DEF 424
3 100019 GHI 725
4 100019 543
5 100019 989
6 704561 ABC 955
7 334567 DEF 235
8 334567 ABC 158
9 334567 158
11 628499 853
12 558990 GHI 876
13 558990 DEF 231
14 558990 ABC 498
15 558990 874



Any ideas?

 

[PHV]

Have a look here:
faq701-4233

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[PHV]

So, did you try the Concatenate function ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[nlbertram]

Not yet...it is on my to-do list.