highest / lowest value


Posted by arjan on August 23, 2001 5:55 AM

Here's a real simple question:
Is there a possibility (function?) to show the highest and lowest value in a row or column of numbers without having to sort or write a macro?

Posted by arjan on August 23, 2001 6:00 AM

Sorry, I got it...



Posted by Connie on August 23, 2001 6:16 AM

What you need are the functions MIN and MAX. Just use the formula =MIN(range) or =MAX(range) to find the lowest and highest value.
i.e. =MIN(a1:a20)