Maximum of 30+ values

[hossa_dude]

Hi...I assume my problem is only minor and - again - I'm simply to
stupid to solve it.

What I want to do is derive the minimum and maximum value in a give
column. However, MAX and MIN can - according to Excel - only handle 3
different values. I have to deal with roughly 100.

Any other formula? LARGE didn't do the trick either...:-(

Any comment is appreaciated

Cheers
Joer

 

[georgewang]

hey dude,i think you should try to use a continuous column whic
contains all the values you want as a paramete

 

[hossa_dude]

Hmm.......didn't quite get that......what do you mean?
Could you please explain what you mean by continuous column and value
as parameters?

Cheers
Joer

 

[georgewang]

sorry ,my english is not very good at this point ,ok i try to expres
more clearly,i mean using contiguous range which contains all th
values you may want to get the max or min,in that way ,max functio
will deem the range as one value,is that clear

 

[Jerry W. Lewis]

Not 30 values, 30 arguments, each of which may be a range.
=MAX(A1:A100)
=MAX(A:A)
each use only 1 arguments, though they reference up to 100 and 65,636
values respectively.

Jerry