i am using the following formula to find the last date bob completed his
work 100%

={max(if(col B="Bob", if(col C=1, Col A)))}

Date Name complete%
28/1/6 bob 100%
31/1/6 bob 100%
1/2/6 bob 100%
1/2/6 pete 100%
2/2/6 bob 65%
2/2/6 steff 89%
3/2/6 bob 100%

i would like to amend this formula to find the second to last date bob
completed 100% which would be the 1/2/6


--
ceemo
------------------------------------------------------------------------
ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650
View this thread: http://www.excelforum.com/showthread...hreadid=534334