Pulling high and low numbers

[beaten back]

Is there a formula or way to pull the highest and lowest numbers from a selected range of cells and display them in another?

 

[Mark W.]

=MIN(range)
=MAX(range)

 

[Matt]

Do you want the highest and lowest numbers to be displayed in the same cell, if so do you want the numbers separated?

 

[beaten back]

Thanks, the =MIN, MAX works, but is there a way to omit zeros from the equation?

 

[Mark W.]

On 2002-04-17 09:09, beaten back wrote:
Thanks, the =MIN, MAX works, but is there a way to omit zeros from the equation?

{=MIN(IF(range,range))}
{=MAX(IF(range,range))}

Note: These are array formulas which must be entered using the Control+Shift+Enter key combination. For more on array formulas see the Excel Help Index topic for "About array formulas and how to enter them".