+ Reply to Thread
Results 1 to 7 of 7

If Cell is blank, enter max date

  1. #1
    Registered User
    Join Date
    05-31-2013
    Location
    Somewhere
    MS-Off Ver
    Excel 2007
    Posts
    72

    If Cell is blank, enter max date

    What I need from a formula is this:

    If a cell in C1:C20 is blank, enter the most recent date from B1:B20.

    I've tried a bunch of different formulas... but its not working out for some reason. Thought I would get a clear head helping me with this....


    Thanks!

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,108

    Re: If Cell is blank, enter max date

    Try something like this...
    =IF(C1="",MAX(B1:B20),"")
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    05-31-2013
    Location
    Somewhere
    MS-Off Ver
    Excel 2007
    Posts
    72

    Re: If Cell is blank, enter max date

    I understand the way it should work... but its not really working the way I need it to. I've attached the document so you can see what I am working on.

    I'm needing to keep the Records page as it is, as the format has to follow a specific way due to regulations from the higher ups....

    I also need to keep an ongoing tally of the times someone takes it out for recording purposes. I'm trying to make it so the Stats page automatically updates as in the end it will be a very large document (only about 20 rows, but with many many columns).

    What I want is if there is an Out date showing, but no in date, showing a return of the item, that the previous date that it was returned show up in the Stats page.

    For example, you will see D. Grant has out H-01, but has not returned it. I need to mark it as last used by the return date of A. Nikonchuk.

    In the end, my goal is so also have it state in the Stats - Currently Out page, that D. Grant took it out on April 1. I'm hoping this makes more sense.
    Attached Files Attached Files

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,108

    Re: If Cell is blank, enter max date

    deleted......

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,108

    Re: If Cell is blank, enter max date

    Try this...
    =IF(COUNT(Records!$B$3:$B$25)<>COUNT(Records!$C$3:$C$25),MAX(Records!$C$3:$C$25),"")

  6. #6
    Registered User
    Join Date
    05-31-2013
    Location
    Somewhere
    MS-Off Ver
    Excel 2007
    Posts
    72

    Re: If Cell is blank, enter max date

    Works. Thanks. Do you mind explaining the reason behind why it works, just so I understand and maybe can apply it to other documents I work on in the future?

    Thanks!

  7. #7
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,108

    Re: If Cell is blank, enter max date

    Sure. It is counting the "in" entries, and comparing that answer with a count of the "out" entries - the theory being that if they match, the item has been returned, but if they dont, it is still outstanding

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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