"Dav" wrote:


=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

Thanks Dave. I have used the formula and from some of the amendments I have done, it either reports the first row in the title column or "complete" if I put 100%s all the way down. Any idea how I could amend to make it skip the 100%s and report the next <100%?

I was thinking of having Complete =1400% For whatever reason it's saying
complete if I autofill 100% in the first 12 rows. I dont know why its
disregarding the last 2.