+ Reply to Thread
Results 1 to 3 of 3

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

  1. #1
    Registered User
    Join Date
    10-03-2017
    Location
    Arizona, USA
    MS-Off Ver
    IDK
    Posts
    2

    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
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor Root_'s Avatar
    Join Date
    07-29-2017
    Location
    _
    MS-Off Ver
    2010+
    Posts
    438

    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. #3
    Registered User
    Join Date
    10-03-2017
    Location
    Arizona, USA
    MS-Off Ver
    IDK
    Posts
    2

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

    Thank you!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 10-06-2014, 11:58 AM
  2. [SOLVED] Counting number of occurrences in a given month
    By tief10 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-16-2014, 02:20 AM
  3. Counting the number of occurrences and spanning midnight
    By allwrighty in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-01-2013, 05:53 PM
  4. [SOLVED] Counting regular occurrences in a specified interval
    By dm2012 in forum Excel General
    Replies: 10
    Last Post: 07-09-2012, 08:56 AM
  5. Counting number of occurrences in a list
    By timtrag12 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-02-2010, 05:31 PM
  6. [SOLVED] Counting number occurrences
    By thermometer in forum Excel General
    Replies: 3
    Last Post: 06-06-2006, 03:10 PM
  7. [SOLVED] Counting number of occurrences
    By LyleB_Austin in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-15-2005, 06:05 PM

Bookmarks

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