Return Value if criteria met

[Bubbles_A]

Hi,

I have a table and want the date value to return to column K whenever the 3rd "B" hits the date.

My formula below is wrong as it is returning a date value of the last "B" that hits the date.

Please Login or Register  to view this content.

Appreciate if you can help me.

Thanks!

[Bo_Ry]

Please try at K10

=IFERROR(INDEX($AR$9:$BI$9,MATCH("b",$AR10:$IB10,)),"")

[Bubbles_A]

I have tried but it is returning date value of 1st "B". I want the date value of 3rd "B" , i.e. result of K10 should be 4/11

[Bo_Ry]

I see, Please try again at K10

=IFERROR(INDEX($9:$9,AGGREGATE(15,6,COLUMN($AR10:$IB10)/($AR10:$FT10="b"),3)),"")

[Bubbles_A]

it works perfectly now. Thanks for the help.