Jan 10 2020 12:32 PM
Jan 10 2020 12:38 PM
Jan 10 2020 12:42 PM
Jan 10 2020 01:59 PM
SolutionFor such model
in G2 it could be
=IFERROR(INDEX($A$2:$A$20,AGGREGATE(15,6,1/($C$2:$C$20=$E$1)*(ROW($C$2:$C$20)-ROW($C$1)),ROW()-ROW($G$1) )),"")
similar in next column, and drag them down.
Jan 10 2020 02:13 PM
Jan 10 2020 01:59 PM
SolutionFor such model
in G2 it could be
=IFERROR(INDEX($A$2:$A$20,AGGREGATE(15,6,1/($C$2:$C$20=$E$1)*(ROW($C$2:$C$20)-ROW($C$1)),ROW()-ROW($G$1) )),"")
similar in next column, and drag them down.