Non Array to extract values if condition is met

Try this in G2:

=IFERROR(INDEX(A:A,AGGREGATE(15,6,ROW(A$2:A$10)/($C$2:$C$10=$E$1),ROWS(G$2:G2))),"")

Phuocam: Not pulling correctly when I adjusted the formula to this:

Please Login or Register  to view this content.

Please help fix. Thanks

=IFERROR(INDEX($A$2:$A$10,AGGREGATE(15,6,ROW(A$2:A$10)/($C$2:$C$10=$E$1),ROWs(G$2:G2))-1),"")

Phuocam: Proposed formula (

Please Login or Register  to view this content.

solution works pulling values in column A into column G. Would like a non-array to pull the corresponding values (column B - dates) for column A to be pulled into column H.

Thanks

use the formula provided in post#2, in G2, and copy down and to right and you will get the desired results in both Cols G (A) & H (B)

Originally Posted by Phuocam

=IFERROR(INDEX(A:A,AGGREGATE(15,6,ROW(A$2:A$10)/($C$2:$C$10=$E$1),ROWS(G$2:G2))),"")

there is no need to modify the initial INDEX range from A:A