Home |
Search |
Today's Posts |
#1
|
|||
|
|||
function that returns a list to a single cell
Hello Everyone,
I'm looking for a function that will do the following: Look for a reference in a column, 2010 for instance, and whenever it finds a 2010 in column "a" it returns what is in the same row in column "b" into a single cell in a format like: a, b, d see the example below: 2010 a 2010 b 4030 c 2010 d |
#2
|
|||
|
|||
How about a User Defined Function:
http://groups.google.co.uk/group/mic...28f1ba868980a8 or http://snipurl.com/i7q1 AdamMCW wrote: Hello Everyone, I'm looking for a function that will do the following: Look for a reference in a column, 2010 for instance, and whenever it finds a 2010 in column "a" it returns what is in the same row in column "b" into a single cell in a format like: a, b, d see the example below: 2010 a 2010 b 4030 c 2010 d -- Dave Peterson |
#3
|
|||
|
|||
Thanks, it worked great.
"Dave Peterson" wrote: How about a User Defined Function: http://groups.google.co.uk/group/mic...28f1ba868980a8 or http://snipurl.com/i7q1 AdamMCW wrote: Hello Everyone, I'm looking for a function that will do the following: Look for a reference in a column, 2010 for instance, and whenever it finds a 2010 in column "a" it returns what is in the same row in column "b" into a single cell in a format like: a, b, d see the example below: 2010 a 2010 b 4030 c 2010 d -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In Cell Validation List & Linked Cell VLOOKUP | Excel Discussion (Misc queries) | |||
copying the function contained within a cell to anouther cell. | Excel Worksheet Functions | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
If function that returns value in a cell. | Excel Worksheet Functions | |||
How do I find the contents of a cell using the "ADDRESS" function. | Excel Worksheet Functions |