=IF(ISERROR(OFFSET(A1,MIN(IF(A1:A14<1,ROW(A1:A14), ""))-1,0)),"complete",OFFSET(A1,MIN(IF(A1:A14<1,ROW(A1: A14),""))-1,0))


entered as an array formula shift ctrl enter

if the range of the % is a1:a14 ammend as appropriate
the red 0 needs to be ammended to the column with the title in 1=b 2=c
etc

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=563851