| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
multiple values in column
I can use
=INDEX($B$1:$B$30,SMALL(IF($A$1:$A$30=$C$1,ROW($A$ 1:$A$30)),ROW(A1))) to get the multiple column values but is there a way so that the return value is returned in the same row i.e. d1, e1, f1 not d1, d2, d3. -- problem |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| finding multiple non-zero values in a column | Excel Worksheet Functions | |||
| Convert Multiple Column Values into 1 column | Excel Worksheet Functions | |||
| Adding multiple values in one column based on multiple values of the same value (text) in another column | Excel Discussion (Misc queries) | |||
| Adding numerical values based on multiple values in another column | Excel Worksheet Functions | |||
| To find Multiple values in column B for a unique value in column A | Excel Worksheet Functions | |||
Threaded Mode
