Oldest date if unresolved=true

  • [TABLE="width: 500"]

    [tr]


    [td]

    Date

    [/td]


    [td]

    Unresolved

    [/td]


    [/tr]


    [tr]


    [td]

    13/08/2013

    [/td]


    [td][/td]


    [/tr]


    [tr]


    [td]

    14/08/2013

    [/td]


    [td]

    Yes

    [/td]


    [/tr]


    [tr]


    [td]

    15/08/2013

    [/td]


    [td]

    Yes

    [/td]


    [/tr]


    [tr]


    [td]

    15/08/2013

    [/td]


    [td][/td]


    [/tr]


    [/TABLE]



    Hi, I am looking for a formula that returns the oldest date from the date column if unresolved=yes. So, with the table above the result would be 14/08/2013.


    Thank you in advance for your help!

  • Re: Oldest date if unresolved=true


    If the dates are in ascending order as shown, then this regular formula could work.


    =INDEX(A1:A5,MATCH("yes",B1:B5,0))


    adjust ranges to suit.

    Where there is a will there are many ways. Finding one that works for you is the challenge!

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!