Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 40
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 806
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 897
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,766
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 806
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Use array for lookup value, to return array of lookups Glen Excel Discussion (Misc queries) 3 May 7th 09 11:55 PM
Max of a Single-Cell Array ajd Excel Worksheet Functions 1 February 22nd 08 07:25 PM
Return Cell Address of MIN value - array formula [email protected] Excel Worksheet Functions 5 July 7th 07 07:14 AM
Multiple Lookups - SIngle Result REBrown Excel Worksheet Functions 8 July 2nd 07 02:48 AM
Entering array in single cell nospaminlich Excel Discussion (Misc queries) 6 February 11th 05 06:01 PM


All times are GMT +1. The time now is 05:27 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"