Are the cells C3 to C35 'numeric' values, ie, does the number show on
the right side or left side of the cell?

Try a helper column which has =value(C3) (down to C35) and test the Max
from there, it should work if your entries are numeric.



Jonibenj Wrote:
I've entered the following formula to find the largest value in a list:

MAX(C3:C3000)

So far, there are values in C3 to C35 - the formula is allowing for
expansion. The only result I can get is zero. Any suggestions?

Jonathan


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=466699