# 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

=MIN(IF(\$B\$2:\$B\$5="yes",\$A\$2:\$A\$5))
Confirm COntrol+Shift+Enter

• 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!

• Re: Oldest date if unresolved=true

Thank you for your help!

## Participate now!

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