+ Reply to Thread
Results 1 to 4 of 4

max date status

  1. #1
    Registered User
    Join Date
    12-03-2008
    Location
    Mumbai
    Posts
    17

    Question max date status

    Hi Guys,
    Pls find attachment for details.

    I want to achieve my status on the latest date. if it is ok then it shows "ok" else it should tel me the status which should be on the latest date.

    Regards

    Kreshnr
    Attached Files Attached Files

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    21,528

    Re: max date status

    Use LOOKUP

    A2: =LOOKUP(REPT("Z",255),$B2:$Z2)
    copy down as required (alter range (B:Z) as required)

  3. #3
    Registered User
    Join Date
    12-03-2008
    Location
    Mumbai
    Posts
    17

    Re: max date status

    ur solution works , but i could not able to understand the calculation method.

    Pls explain

    and how about the way i was doing it with offset.. why it was not working.

    Thanx and regards

    kreshnr

  4. #4
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    21,528

    Re: max date status

    See: http://www.xldynamic.com/source/xld....html#last_text

    I confess I didn't look at your formula, note however OFFSET is Volatile so best avoided when possible (for info. on Volatility see link in my sig.)

+ 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