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" <chunky@discussions.microsoft.com> wrote in message
news:6EDBF14C-D332-430F-A082-AED014980C05@microsoft.com...
> trying to create a cell that will choose the greatest number out of a
> column
> of entries