return array formula lookups in to one single cell

[ivory_kitten]

i have copied the technique described here:
http://office.microsoft.com/en-us/excel/HA012260381033.aspx

and the formula is working, listing the multiple matches in subsequent rows

however due to varying amounts of data for each lookup, i am wondering how
to go about combing all the values in to one cell, separated by commas?

so instead of saying:
Ashish 234
534
834

it would say
Ashish 234, 534, 834

i do not want to use VBA.

Thanks!

 

[Bernd P]

Hello,

IMHO not possible without VBA because CONCATENATE cannot concatenate
arrays.

I suggest to use my UDF Cfreq:
http://sulprobil.com/html/cfreq.html

Regards,
Bernd

 

[JP]

Here's one approach but it does require VBA.

http://www.mcgimpsey.com/excel/subs/mergedata.html#mergeselection

--JP

 

[Ashish Mathur]

Hi,

You may use the MCONCAT function. Please note that the mconcat function can
be used only after downloading and installing this add-in -
http://www.download.com/Morefunc/3000-2077_4-10423159.html

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[Bernd P]

Hello,

Using a "non-open source" add in?

That is my number 1 "Don't":
http://sulprobil.com/html/excel_don_ts.html

Regards,
Bernd