Maximum of 30+ values

  • Thread starter Thread starter hossa_dude
  • Start date Start date
H

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
 
hey dude,i think you should try to use a continuous column whic
contains all the values you want as a paramete
 
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
 
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
 
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
 
Back
Top