+ Reply to Thread
Results 1 to 2 of 2

Start a Count from a cell dependent on the value of another

  1. #1
    Registered User
    Join Date
    10-01-2017
    Location
    Colchester , England
    MS-Off Ver
    2016
    Posts
    7

    Start a Count from a cell dependent on the value of another

    In the attached you can see that cell E12 counts the day until the next service of a Generator. In Row 4 the status of the set is manual entered; On = On (Cell BZ120, GLS= standby (Cell BZ11 counts the days in standby). There is a period of 21 days between services.

    The issue i have is that the count of stand by days needs to begin at the start of the month previous to the current however a service could land at any time in the month. This is affecting the 'Days to next Service' Cell E12 as the Count is including standby day before the service.

    In this example it should read 11 days however it is counting the 3 days standby from before the service.

    Is there a way of finding the service in Row 10 (Cell AD11) and then counting how many standby days there have been between then and today.
    Attached Files Attached Files

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,910

    Re: Start a Count from a cell dependent on the value of another

    How do you know what a standby day is? Is it reflected in any of the rows?

    At any rate, the following formula, entered as an array formula will yield the column in which the last service occurred: =MAX(($L$10:$BU$10<>"")*COLUMN($L$10:$BU$10))
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

+ 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. [SOLVED] How can I create dependent & dynamic DropDown lists that start with a certain string?
    By mcclausky in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-17-2016, 01:44 PM
  2. Replies: 6
    Last Post: 05-11-2016, 10:57 PM
  3. Replies: 4
    Last Post: 12-10-2013, 06:41 PM
  4. Replies: 2
    Last Post: 08-16-2013, 08:45 AM
  5. Copy range and autofill ranges dependent on cell count in column A
    By thylander in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-11-2011, 09:26 AM
  6. Start count over after blank cell
    By RPS4444 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-02-2008, 11:27 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