Hi Sige

As you well know from our previous "conversations", I am always in
favour of the simple solution.
I don't really see too much difference between this problem, and one you
posted last October.

If in another column you used
=--(COUNTA(D1:M1)0)*ROW()
Then your answer is simply
=MAX(C:C) (or whatever column you used for the formula above.

--
Regards

Roger Govier


"Sige" wrote in message
oups.com...
If I would like to find the "MAX ROW" for eg.10 columns, eg. D:M

Do you have any suggestions on that matter for this formula?

=MAX((IF(ISNUMBER(MATCH(REPT("z",255),D:D)),MAX(MA TCH(REPT("z",255),D:D)),0**)

),(IF(ISNUMBER(MATCH(9.99999999999999E+307,D:D)),M AX(MATCH(9.99999999999999**E

+307,D:D)),0)))

With array formulas, no prob:
{=MAX(IF(D1:M65535<"";ROW(D1:M65535)))}
{=MAX(ISNUMBER(D1:M65535)*ROW(D1:M65535))}
{=MAX(NOT(ISBLANK(D1:M65535))*ROW(D1:M65535))}

Best Regards Sige