fetch item based on sales rep name, and display downward without blank.

[superjoejoe2000]

Hello, everyone,

(Please see attachment), need help to display result item downward, without blank, based on sales rep names,

Thank you in advance.

[Glenn Kennedy]

In B11, copied across and down:

=IFERROR(INDEX($G:$G,AGGREGATE(15,6,ROW($B$4:$E$6)/($B$4:$E$6=B$10),ROWS(B$11:B11))),"")

[Phuocam]

Try this in B11:

=IFERROR(INDEX($G$4:$G$6,AGGREGATE(15,6,ROW($B$4:$E$6)/($B$4:$E$6=B$10),ROWS(A$11:A11))-ROW($B$3)),"")

[superjoejoe2000]

Thank You, Glenn & Phuocam
Both Formulas work like charm.

By the way, there is:
AGGREGATE(15,6

What is 15 & 6?
Do they will always 15 & 6 in every condition?

[Glenn Kennedy]

15 = small, 6 = ignore errors so i't retruning the values in ascending order of occurrence in B4 to E6.

[superjoejoe2000]

wow, thank you again