Unique Values in Groups

[Stephen_IV]

Below is a breakdown of what I am looking for. I would like to be able to get unique values in each group. For instance ID number 777 has 6 values in the group out of those I would like 5,6,14,15 to be pulled out. I have a formula I stole from Domenic (Column G =SUBSTITUTE(MCONCAT(UNIQUEVALUES(IF($A$2:$A$35=E2,", "&$C$2:$C$35,""),1)),", ","",1)) and tried to adapt it but it does not do exactly what I want but it is close. Could someone please have a look at this. Thanks in advance Stephen

Book1
	A	B	C	D	E	F	G	H
1						# Accomodations	Uniques	This is what I want
2	777	1	5,6,14,15		777	20	5,14,15, 5,6,14,15	5,6,14,15
3	777	2	5,6,14,15		888	13	5,14,15, 5,14,15,26, 5,14,26	5,14,15,26
4	777	3	5,14,15		999	18	5,14,15, 6,14,15	5,6,14,15
5	777	4	5,14,15		444	16	14,15, 5,14,15, 6,14,15	5,6,14,15
6	777	5	5,14,15		555	12	14,15, 6,14,15	6,14,15
7	777	6	5,14,15		333	7	14,15, 21,22	14,15,21,22
8	888	3	5,14,26
9	888	4	5,14,15,26
10	888	5	5,14,15
11	888	6	5,14,15
12	999	1	6,14,15
13	999	2	6,14,15
14	999	3	5,14,15
15	999	4	5,14,15
16	999	5	5,14,15
17	999	6	5,14,15
18	444	1	6,14,15
19	444	2	6,14,15
20	444	3	5,14,15
21	444	4	5,14,15
22	444	5	14,15
23	444	6	5,14,15
24	555	1	6,14,15
25	555	2	6,14,15
26	555	3	14,15
27	555	4	14,15
28	555	5	14,15
29	555	6	14,15
30	333	1	14,15
31	333	2	14,15
32	333	3	14,15
33	333	4	14,15
34	333	5	21,22
35	333	6	14,15
Sheet1

 

[Krishnakumar]

Hi,

Download KCONCAT UDF.

Try

=KCONCAT(IF($A$2:$A$35=E2,$C$2:$C$35),1)

HTH

 

[Stephen_IV]

Krishnakumar,
You are a lifesaver. Works perfect. I could not that you enough! Thanks you again!

 

[Krishnakumar]

Krishnakumar,
You are a lifesaver. Works perfect. I could not that you enough! Thanks you again!

You are welcome and thanks for the feedback