# Interval between Occurrences, Counting gap from >= number to the next number

1. ## Interval between Occurrences, Counting gap from >= number to the next number

Just for aurguments sake i have read
Calculating the Interval between Occurrences

And
Calculating the interval difference between occurrences

neither help me, as i need to also include a greater and/or Equal to in part of the equation

i have included a example file of what i would LIKE it to do
if you can help me out i cant seem to figure it out on how to make the >= applie.... the other formulas WORK but only for absolute values ``Please Login or Register  to view this content.``
but i need it tto work with Greater and or equal to not a absolute match only

THANK you for any help i can get  Register To Reply

2. ## Re: Interval between Occurrences, Counting gap from >= number to the next number

Try placing the following array formula (to be entered using Ctrl+Shift+Enter, not just Enter) in cell B3 and drag-copying it down as needed:

=IF(A3<\$F\$1,"",IFERROR(MATCH(TRUE,A4:A\$65536>=\$F\$1,0),""))  Register To Reply

3. ## Re: Interval between Occurrences, Counting gap from >= number to the next number

Thank you!  Register To Reply