Locked - Posting on two forums >> Min Value & If Statements.

[taji]

Hi

Could someone please help me with this.

What I need to do is to have 2 rows (A & B). Row "A" is going to have a list of dates and row "B" will either have "Yes" or "No" vaules.

What I need to do is to return the value with the oldest date but only if it has "No" in row "B"

Thanks

[jasoncw]

Try this.

=MIN(IF(B1:B10="no",A1:A10))

It is an array formula, so you will need to use CTRL + SHIFT + ENTER after you type it in, rather than just ENTER.

HTH

Jason

[starguy]

Hi

Could someone please help me with this.

What I need to do is to have 2 rows (A & B). Row "A" is going to have a list of dates and row "B" will either have "Yes" or "No" vaules.

What I need to do is to return the value with the oldest date but only if it has "No" in row "B"

Thanks

try this
=if(and(min($A$1:$A$10)=A1,B1="No"),A1,"")