ExcelBanter - multiple values in column

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - multiple values in column (https://www.excelbanter.com/excel-worksheet-functions/195363-multiple-values-column.html)

bigproblem

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

Teethless mama

multiple values in column

=INDEX($B$1:$B$30,SMALL(IF($A$1:$A$30=$C$1,ROW($A$ 1:$A$30)),COLUMNS($D:D)))

ctrl+shift+enter, not just enter
copy across

"bigproblem" wrote:

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

bigproblem

multiple values in column

You rock !!! Thank you, you saved me a lot of time !!!

--
problem

"Teethless mama" wrote:

=INDEX($B$1:$B$30,SMALL(IF($A$1:$A$30=$C$1,ROW($A$ 1:$A$30)),COLUMNS($D:D)))

ctrl+shift+enter, not just enter
copy across

"bigproblem" wrote:

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

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