I am reposting since I understand a bit more what I am trying to do, but not
sure how to formulate it. We have a front page that displays everybodys
bi-weekly reports. We needed 2 more columns that display what percentage of
their project is complete and which of the 7 phases they are in.
The percent complete column is L101. L104, L107, L110, etc etc. merged
cells. So basically L101:L119.
I would like the formula to find the first <100% and report the title of the
phase in that same row A101:119. Even if there are other 100%s in the column,
it should report the first one it comes across since thats the earliest phase
that still needs to be completed. They shouldn't finish out of order, but
there is human error. (*0,-6)? There are merged cells between A and L.
If all phases are 100%, then report "Complete". It reads complete sometimes,
but I am not quite sure what it is looking for since it will report complete
when the first 6 are 100%. I would like all 7. I am thinking Complete should
equal 700%. It would probably be easier than looking for all rows to equal
100%.
And thank you Dave for the formula you gave me. I was just running into some
snags and I didnt quite know what I wanted to say the first time around.
Thanks ahead of time,
Jonathan
Bookmarks