| 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! |
| 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) | |||
Threaded Mode
