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

chunky · Aug 22, 2006

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

RagDyer · Aug 22, 2006

With values in A1 to A100:

=Max(A1:A100)

OR

=Large(A1:A100,1)