Create list of occurrences

[Bevilready]

Hello,
I have two columns of data, column A displays a list of areas and column B displays a list of codes. I would like to summarise the data to show which areas the codes exist in.
Would someone be able to suggest a formula that would work please?
Thanks.

 

[vladimiratanasiu]

Hello,
I have two columns of data, column A displays a list of areas and column B displays a list of codes. I would like to summarise the data to show which areas the codes exist in.
Would someone be able to suggest a formula that would work please?
Thanks.

View attachment 72374

Is it what you need?

Book1
	A	B	C	D
1	Areas	Codes	Unique codes	Joined areas
2	1	T1	T1	1,2
3	2	T1	T3	3,11
4	3	T3	T4	4,13,14
5	4	T4	T5	5,6
6	5	T5	T7	7,15
7	6	T5	T8	8
8	7	T7	T9	9,18
9	8	T8	T10	10
10	9	T9	T12	12
11	10	T10	T16	16
12	11	T3	T17	17
13	12	T12
14	13	T4
15	14	T4
16	15	T7
17	16	T16
18	17	T17
19	18	T9
Sheet1

Cell Formulas
Range	Formula
C2:C19	C2	=IFERROR(INDEX($B$2:$B$19,MATCH(0,INDEX(COUNTIF($C$1:C1,$B$2:$B$19),0,0),0)),"")
D2:D19	D2	=TEXTJOIN(",",TRUE,IF($B$2:$B$19=C2,$A$2:$A$19,""))
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[Bevilready]

Thank you, that is exactly what I wanted.

 

[vladimiratanasiu]

Thank you, that is exactly what I wanted.

You're welcome and thank you for the feedback.