software

Hallo

My problem:
I have decimal numbers in column A, extending from Cell A1 to cell A100In Cell B1 I type the number 10
And
In cell B2 I type the number 50

What do I have to type in Cell C1 to calculate the maximum value from
area A10 to A50?
Please consider that 10 and 50 are the numbers I typed on cell B1 and
B2…--
istratos
------------------------------------------------------------------------
istratos's Profile: www.excelforum.com/member.php...oamp;userid=33367
View this thread: www.excelforum.com/showthread...hreadid=532559=MAX(INDIRECT(quot;Aquot;amp;B1amp;quot;:Aquot;amp;B2))

HTH
--
AP

quot;istratosquot; gt; a écrit
dans le message de
...
gt;
gt; Hallo
gt;
gt; My problem:
gt; I have decimal numbers in column A, extending from Cell A1 to cell A100
gt;
gt;
gt; In Cell B1 I type the number 10
gt; And
gt; In cell B2 I type the number 50
gt;
gt; What do I have to type in Cell C1 to calculate the maximum value from
gt; area A10 to A50?
gt; Please consider that 10 and 50 are the numbers I typed on cell B1 and
gt; B2.
gt;
gt;
gt; --
gt; istratos
gt; ------------------------------------------------------------------------
gt; istratos's Profile:
www.excelforum.com/member.php...oamp;userid=33367
gt; View this thread: www.excelforum.com/showthread...hreadid=532559
gt;