Results 1 to 6 of 6

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

Threaded View

  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
« 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