Running counter which resets after threshold

[kk1352]

Hi all,

I'm trying to figure out how to create a counter for how many times a fruit appears, however the count only resets when it appears again after 60 days. I've attached a sample workbook- column F has a running count which resets when the next time that fruit appears is 60 days later, but I cant seem to figure out a formula in column G which isolates that final number for that particular fruit before the counter resets.

Any help would be appreciated!

Thanks

[samba_ravi]

G5=IF(COUNTIF(C5:INDEX(C:C,LOOKUP(2,1/((C5:C$17=C5)*(B5:B$17<=B5+$C$2)),ROW(B5:B$17))),C5)=1,COUNTIF(C5:INDEX(C$5:C5,MATCH(1,INDEX((C$5:C5=C5)*(B$5:B5>=B5-+$C$2),0),0)),C5),"")

=IF(COUNTIF(C5:INDEX(C:C,LOOKUP(2,1/((C5:C$17=C5)*(B5:B$17<=B5+$C$2)),ROW(B5:B$17))),C5)=1,COUNTIF(C5:INDEX(C$5:C5,MATCH(1,INDEX((C$5:C5=C5)*(B$5:B5>=B5-+$C$2),0),0)),C5),"")

Try this and copy towards down

[kk1352]

G5=IF(COUNTIF(C5:INDEX(C:C,LOOKUP(2,1/((C5:C$17=C5)*(B5:B$17<=B5+$C$2)),ROW(B5:B$17))),C5)=1,COUNTIF(C5:INDEX(C$5:C5,MATCH(1,INDEX((C$5:C5=C5)*(B$5:B5>=B5-+$C$2),0),0)),C5),"")

=IF(COUNTIF(C5:INDEX(C:C,LOOKUP(2,1/((C5:C$17=C5)*(B5:B$17<=B5+$C$2)),ROW(B5:B$17))),C5)=1,COUNTIF(C5:INDEX(C$5:C5,MATCH(1,INDEX((C$5:C5=C5)*(B$5:B5>=B5-+$C$2),0),0)),C5),"")

Try this and copy towards down

Thank you, works great. Definitely more complicated than what I thought, no wonder I couldn't figure it out!