I have a spreadsheet that looks like this.
Date tank tank
1 2

1/10/06 999 7500



This data is kept on a daily basis. I am trying to find a formula that
will return the latest date, but only if the tank value is at 999, as
in tank 1
I have tried =MAX(IF(tank1=999,A3:A47," ")) returns Max of A3:A47
only
and =IF(tank1=999,MAX(A4:A48)," ") returns Max of A only
both return only the latetest date. What am I missing?
Thanks in advance
Deb


--
Deb Pingel
------------------------------------------------------------------------
Deb Pingel's Profile: http://www.excelforum.com/member.php...o&userid=20119
View this thread: http://www.excelforum.com/showthread...hreadid=513028