I need to use the largest figure in a part of column D. The part is
defined with the lowest value of the range always being D2 and the
highest being determined by the number of used cells in column B, eg.
if column B contains 32 used cells then the range is (D2:D31)

I tried this formula:
=MAX(D2:ADDRESS(COUNT(B:B)-1;4;4))+1
but I cannot enter it. I get a message that it contains an error, just
as if I've forgotten a parenthesis or something like that.

I have tested the formula =ADDRESS(COUNT(B:B)-1;4;4) in spare cell in
the sheet where it works fine and writes D31 when there are 32 used
cells in column B.
Why doesn't it work in the MAX formual?

NSV


--
nsv
------------------------------------------------------------------------
nsv's Profile: http://www.excelforum.com/member.php...o&userid=26500
View this thread: http://www.excelforum.com/showthread...hreadid=563195