+ Reply to Thread
Results 1 to 6 of 6

If all cells are complete select the latest date, if at least one is blank leave it BLANK

  1. 05-28-2013, 05:35 AM #1
    Abu Abdurakhim
    Abu Abdurakhim is offline
    Registered User
    Join Date
    05-24-2013
    Location
    Aktobe
    MS-Off Ver
    Excel 2010
    Posts
    20

    If all cells are complete select the latest date, if at least one is blank leave it BLANK

    Dear Experts!

    I need your assistance in solving the below issue. It looks a challenge to me and i am not sure if it is at all plausible to solve.

    I need a formula that will look up into certain cells and if all cells are completed it will display the one value that is the latest by date (Q2, Q3, July, Q4). If at least one cell is blank then it will display BLANK.

    The cells may be located at different places around the worksheet.

    Thank you very much for your every assistance! Please, see attached file...
    Attached Files Attached Files
    Last edited by Abu Abdurakhim; 05-29-2013 at 12:26 AM.
    Reply With QuoteRegister To Reply
  2. 05-28-2013, 08:00 AM #2
    Abu Abdurakhim
    Abu Abdurakhim is offline
    Registered User
    Join Date
    05-24-2013
    Location
    Aktobe
    MS-Off Ver
    Excel 2010
    Posts
    20

    Re: If all cells are complete select the latest date, if at least one is blank leave it BL

    Any magic formula please?
    Reply With QuoteRegister To Reply
  3. 05-28-2013, 10:54 AM #3
    Abu Abdurakhim
    Abu Abdurakhim is offline
    Registered User
    Join Date
    05-24-2013
    Location
    Aktobe
    MS-Off Ver
    Excel 2010
    Posts
    20

    Re: If all cells are complete select the latest date, if at least one is blank leave it BL

    Pretty urgent now... Thanks!
    Reply With QuoteRegister To Reply
  4. 05-28-2013, 11:39 PM #4
    Abu Abdurakhim
    Abu Abdurakhim is offline
    Registered User
    Join Date
    05-24-2013
    Location
    Aktobe
    MS-Off Ver
    Excel 2010
    Posts
    20

    Re: If all cells are complete select the latest date, if at least one is blank leave it BL

    I have tried to simplify the task by having dates in one row or column. So if i have dates in cell range A1:A7, i need a formula to look into the cell range and return with the maximum value, but if at least one cell within the range is blank, it should show blank. So, e.g.:
    A1 Q2
    A2 July
    A3 Q1 and so on, then in B1 formula will return July since it is later than Q1 and 2.
    Thanks!
    Reply With QuoteRegister To Reply
  5. 05-29-2013, 12:19 AM #5
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,926

    Re: If all cells are complete select the latest date, if at least one is blank leave it BL

    According for forum rules, please wait at least 24 hours (1 day) before bumping your thread if you have not received a response

    Looking at your file, how would anyone know that Q3 (or any Q) is later than July (or any month name)?
    Also, if you have updated/changed your sample file, please let us see it?
    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
    Reply With QuoteRegister To Reply
  6. 05-29-2013, 12:27 AM #6
    Abu Abdurakhim
    Abu Abdurakhim is offline
    Registered User
    Join Date
    05-24-2013
    Location
    Aktobe
    MS-Off Ver
    Excel 2010
    Posts
    20

    Re: If all cells are complete select the latest date, if at least one is blank leave it BL

    I apologize for being inpatient!
    Please, find attached updated file. I have substituted Quarters by months....
    Thanks!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1