Min() and Max() on more than 30 numbers.

[Fuga]

Hi,

I understand there´s a limit on the min and max functions to 30 numbers.

How do I find the highest value among, say, a thousand numbers?

Fuga.

 

[Brianwarnock]

Are you misunderstanding the help, or do I not understand your problem?

You can code =MAX(a1:a3000)
=max(a1:a300,b1:b36,.....) with upto 30 options

Does this help

Brian

 

[Fuga]

Thank you.

Yes, it seems I´ve missunderstood the help.

I thought you could only find the highest of (a1:a30).

the thing is when I look at the results it looks like it only calculates 30 numbers. Is there a setting somewhere that I might have missed?

Fuga.

 

[Brianwarnock]

I don't know of any settings that affect this and a simple test I just did to find the max in 6000 rows had no problems

Brian