Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Use array for lookup value, to return array of lookups | Excel Discussion (Misc queries) | |||
Max of a Single-Cell Array | Excel Worksheet Functions | |||
Return Cell Address of MIN value - array formula | Excel Worksheet Functions | |||
Multiple Lookups - SIngle Result | Excel Worksheet Functions | |||
Entering array in single cell | Excel Discussion (Misc queries) |