You're looking for the formula =max(cellrange)

That will return the highest value entered in the range of cells.


"Neil Holden" wrote:

Hello, can anyone help me please!!??

I have a cell named "% Compete" and columns named Week 1, Week 2, Week 3,
Week 4 and so on up to week 28

When the user types in week 1, 50% and then 60% in week 2 I need the cell "%
complete" to automatically update each time the user inputs the % complete.

Please help!!