|
View Full Version : Min() and Max() on more than 30 numbers. Fuga 01-09-2006, 01:02 AM 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 01-09-2006, 01:28 AM 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 01-09-2006, 05:46 AM 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 01-09-2006, 06:10 AM 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 |