multiple values in column

B

bigproblem

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

Teethless mama

=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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Weigh tasks 0
Fill cells based on the other 3 cells unique combination the value on the target cell 0
Row references 1
return multiple values when within range (greater than and less than) 11
COMPARING TIMES AND DISPLAYING TEXT USING IF CONDITION 3
Help needed regarding calculating time 0
problem with time subtraction 7
column to row draging 1

Top