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 |
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 |