Averge and or Maximum

P

PCOR

I have in col A a series of numbers to which a new entry is added from time
to time
I would like to have a cell to the right of this col display the smallest
and an other cell display the largest number in col A
I would appreciate any help I can get
Ian
 
R

RagDyer

Try these two:

=MAX(A:A)

=MIN(A:A)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I have in col A a series of numbers to which a new entry is added from time
to time
I would like to have a cell to the right of this col display the smallest
and an other cell display the largest number in col A
I would appreciate any help I can get
Ian
 
A

Art

PCOR,

Try Min(A:A) and Max(A:A) This assumes that there is nothing else in column A. If there is, then use something like: Min(a4:a2000) or whatever row numbers make sense.

Art
 
Top