Results 1 to 9 of 9

Counting days until threshold reached

Threaded View

larynx Counting days until threshold... 01-18-2022, 10:06 AM
KOKOSEK Re: Counting days until... 01-18-2022, 11:07 AM
larynx Re: Counting days until... 01-18-2022, 11:44 AM
JeteMc Re: Counting days until... 01-18-2022, 11:29 PM
larynx Re: Counting days until... 01-19-2022, 03:38 AM
JohnTopley Re: Counting days until... 01-19-2022, 03:49 AM
muhammadridho30 Re: Counting days until... 01-19-2022, 04:51 AM
JohnTopley Re: Counting days until... 01-19-2022, 07:26 AM
JeteMc Re: Counting days until... 01-19-2022, 10:34 AM
  1. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 365 version 2501
    Posts
    18,897

    Re: Counting days until threshold reached

    I am a bit confused myself as to whether the request is for the date or the number of days, so I put dates in columns E:G and number of days in columns I:K.
    Column H is a helper column populated using: =SUMIFS(D$2:D2,A$2:A2,A2)
    Columns E:G are populated using:
    Formula: copy to clipboard
    =IFERROR(INDEX($B$2:$B$82,MATCH(INDEX($H$2:$H$82,AGGREGATE(15,6,(ROW($H$2:$H$82)-ROW($H$1))/($A$2:$A$82=$A2)/($H$2:$H$82-IF($A1=$A2,$H1,0)>=E$1),1)),$H$2:$H$82,0)),"N/A")

    Columns I:K are populated using: =IF(E2="N/A","N/A",E2-$B2)
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 4
    Last Post: 12-12-2018, 12:34 AM
  2. Counting Times Threshold is Reached
    By Casval in forum Excel General
    Replies: 4
    Last Post: 02-04-2018, 05:37 AM
  3. Replies: 1
    Last Post: 11-30-2016, 08:02 PM
  4. [SOLVED] Move specific cells to a new sheet when a date is reached or 30 days from being reached
    By Albert Dirk in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-26-2016, 04:44 AM
  5. [SOLVED] Need to formulate trigger once a certain value or milestone or threshold has been reached
    By KaziProttoy in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 08-09-2015, 11:03 AM
  6. [SOLVED] Find first cell where threshold value is reached, return value from adjacent column
    By CatSqueezer in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 12-06-2013, 08:49 PM
  7. [SOLVED] Counting days till value is reached
    By Montoro22 in forum Excel General
    Replies: 11
    Last Post: 07-06-2012, 11:09 AM

Tags for this Thread

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