return array formula lookups in to one single cell
 

i have copied the technique described he
http://office.microsoft.com/en-us/ex...260381033.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!

return array formula lookups in to one single cell
 

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

return array formula lookups in to one single cell
 

Here's one approach but it does require VBA.

http://www.mcgimpsey.com/excel/subs/...mergeselection

--JP

On Sep 25, 10:52*am, ivory_kitten
wrote:
i have copied the technique described hehttp://office.microsoft.com/en-us/ex...260381033.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!

return array formula lookups in to one single cell
 

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/300...-10423159.html

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"ivory_kitten" wrote in message
...
i have copied the technique described he
http://office.microsoft.com/en-us/ex...260381033.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!

return array formula lookups in to one single cell
 

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