pick the greatest number out of a group for the total box

[chunky]

trying to create a cell that will choose the greatest number out of a column
of entries

[RagDyer]

With values in A1 to A100:

=Max(A1:A100)

OR

=Large(A1:A100,1)

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"chunky" <[email protected]> wrote in message
news:[email protected]...
> trying to create a cell that will choose the greatest number out of a
> column
> of entries