On Mar 27, 7:12 pm, "Jenny" wrote:
Thanks Domenic
I tried your formulas. The first one works well is exactly what I
want. Can you tell me what dose bif number for...?

Thanks Meatshield

I also tried your formula but the results are always "Over".....

Jenny

Hmm.. When you enter the array formula, you'll have to make sure it is
pointing to the correct row.. The output will be something like "D2"
If the percentages are in row 5, the formula will not return the
correct result. Assuming that the formula will be looking for blank
cells in the same row as itself, you can change the formula to be:
ADDRESS(ROW(),MATCH(TRUE,A29:L29="",0),4)
entered as an array formula.
I hope that helps.