Unique Concatenate Range, multiple rows, Index Match Mutliple Criteria

[youngja]

Book2.xlsmHello Excel Gurus,

The problem I am trying to solve is to have a function that allows for concatenated criteria which matches concatenated range, then takes information from the relevant rows and uniquely concatenates the results..

Program Sub Program Project Manager Client 1 Client 2 Client 3
Program 1 A 1 John CSIRO
Program 1 B 1 Bob Uni LLS
Program 1 B 2 John CMA UNI TAFE
Program 2 A 1 Alex LLS CSIRO
Program 2 A 2 Alex CMA LLS TAFE
Program 3 C 1 Sue Private


Example :
Program Program 1
Sub Program B

Unique Concatenated Result (MANAGERS): Bob, John
Unique Concatenated Result CLIENTS Uni, LLS, CMA, TAFE



Program Program 2
Sub Program A

Unique Concatenated Result (MANAGERS): Alex
Unique Concatenated Result CLIENTS LLS, CSIRO, CMA, TAFE


Regards

John