# 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

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),""))

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

Thank you!

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1