Results 1 to 4 of 4

Thread: Daily Log

  1. #1

    Lightbulb Daily Log



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi, i have been working on a Daily Log for a while now and have gotten this far reworking formulas to supply Elapsed times and Trip miles Etc (Please see Attached). Daily Log.xlsxSeems I am now stuck at the personal miles column. I would like to have a formula that would subtract the first number after a series of Blank cells (they do contain formulas so are not actually blank) from the last cell containing a number before this paticular series of Blank cells, this formula idealy would repeat throughout the whole column making it auto filling if possible.

    Sure would apperciate any help on this

    Thanks
    Jim
    Last edited by Jim G; 2014-02-07 at 04:30 AM.

  2. #2
    Conjurer Simi's Avatar
    Join Date
    Feb 2012
    Location
    Utah, USA
    Posts
    187
    Articles
    0
    I am a little confused as to what you are trying to accomplish with this.
    If by example you want to show a 0, for personal miles between oct 1 and oct 2, and then show 18 for personal miles between oct 3 and oct 4 this will work.
    However you have some inconsistency with the dates in column A. There is also not a row with just a date for oct 4. and from row 50 down your date format changed to text instead of dates.
    This formula will need some additional error checking and your data needs to be more uniform.

    but try this in column J.

    =IF(ISBLANK(E3),MIN(IF(IFERROR(DAY(IF(ISBLANK(A:A),"",A:A)),"")=DAY(A3)+1,IF(ISBLANK(E:E),"",E:E),""))-MAX(IF(IFERROR(DAY(IF(ISBLANK(A:A),"",A:A)),"")=DAY(A3),E:E,"")),"")

    I started in J3 and copied it down.
    Hopefully this will get you on the right track for what you want to accomplish.

  3. #3

    Daily Log Solution

    Hi Simi, Thanks for the reply.I was not able to get it to work but did get me think again. I found a solution to my problem, the problem was mainly to find a formula to search out the next higest number in a column of numbers regardless of empty spaces. i will post an attachment so you can see if you are intrested. i know that it is incomplete in dealing with the first numbers in the column and the last as well as blank spaces over 3 in a row. that just needs a little more work to extend into these areas.
    regards,
    Jim.
    Attached Files Attached Files

  4. #4
    Conjurer Simi's Avatar
    Join Date
    Feb 2012
    Location
    Utah, USA
    Posts
    187
    Articles
    0
    Jim, I'm sorry I forgot to mention that you need to enter the formula as an array formula, by hitting ctrl+shift+enter to exit the cell.

Posting Permissions

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