Another option then using the MCONCAT addin formula

[suprsnipes]

Is their another option then using the MCONACT addin formula below;

=TRIM(MCONCAT(IF(sl!$I$3:$I$18=la!$H224," "&sl!$J$3:$J$18,"")))

Thank you in advance,
suprsnipes

 

[GlennUK]

You would need something in VBA, unless you want to do some formulas on each row to build the appropriate string, like:

Excel Workbook
	I	J	K	L
1			Bill
2
3	Fred	Portland
4	Bill	Warwick	Warwick
5	Bob	Fleet	Warwick
6	Fred	Bristol	Warwick
7	Bill	Weymouth	Warwick Weymouth
8	Bob	Rhyll	Warwick Weymouth
9	Fred	Paris	Warwick Weymouth
10	Bill	Rome	Warwick Weymouth Rome
11	Bob	Cardiff	Warwick Weymouth Rome
12	Fred	Glasgow	Warwick Weymouth Rome
13	Bill	Manchester	Warwick Weymouth Rome Manchester
14	Bob	Plymouth	Warwick Weymouth Rome Manchester
15	Fred	Bath	Warwick Weymouth Rome Manchester
16	Bill	Ely	Warwick Weymouth Rome Manchester Ely
17	Bob	Esher	Warwick Weymouth Rome Manchester Ely
18	Fred	Derby	Warwick Weymouth Rome Manchester Ely
Sheet2

... the last cell in K has the result you want.

 

[suprsnipes]

It would seem I'm still better of using the MCONCAT function. The reason I asked the question in the first place was because I thought that perhaps one of the addins was causing Excel to crash. I have upgraded my version of Excel 2000 to Excel 2010 and the crashing event has stopped and I'm still using my Morefunc add in with no drama's at this stage.

Thanks for the reply by the way.