Find the first column to be 100%

[scott]

I have an implementation section of a revenue template.

Col B = Currently has the # of months until full utilization ( 7 months
for example)

Col C - has an error check, so that after the VPs make their changes
they are supposed to go back and change the column B value, but they are
not and I am being forced to correct the errors
=IF(OFFSET(B21,0,B21+1)<>100%,"ERROR",IF(OFFSET(B21,0,B21)=100%,"ERROR",""))

Starting in Column D through Column R
are the manually entered percentages of utilziation, i.e.
0%,0%,5%,25%,50%,75%,100% for the remaining columns

I would like the find a formula to tell me how months it takes to get to
100% based in the input data in D through R, but I have not been able to
figure it out.

Thanks in advance.

Scott

 

[scott]

Thanks.

I figured it out. = match(1,d21:r21,0)