Thanks G,alternative to any formula is simply using a pivot and slicer.
Thank you Bosco, this is really helpfulFormula solution,
In "Sheet 3" B3 formula copied down :
=IFERROR(INDEX(Sheet1!B:B,AGGREGATE(15,6,ROW(Sheet1!A$2:A$99)/(Sheet1!A$2:A$99=LOOKUP("zzz",A$3:A3)),ROW(A1)-MATCH("zz",A$3:A3)+1)),"")
View attachment 65832
Regards
Bosco
Formula solution,
In "Sheet 3" B3 formula copied down :
=IFERROR(INDEX(Sheet1!B:B,AGGREGATE(15,6,ROW(Sheet1!A$2:A$99)/(Sheet1!A$2:A$99=LOOKUP("zzz",A$3:A3)),ROW(A1)-MATCH("zz",A$3:A3)+1)),"")
View attachment 65832
Regards
Bosco