RANGE

[gib6717]

I was wondering if Excel had a function that would find the range of a row of numbers (highest minus the lowest) I have a large sample and it would be cumbersome and error prone to do it manually. Thanks

 

[Joe4]

Take a look at the MIN and MAX functions in Excel help. It should do exactly this.

 

[Davers]

Hi Gib,

This formula:

=LARGE(A1:A24,1)

will return the 1st largest number in a range...in this case A1:A24. The ,1 is telling it to return the 1st largest number, a 2 would be the second largest number...etc...if that makes sense...

Hope this helps..

Dave

 

[AlohaJulio]

If you are just looking for the number of rows in a range, you can use the ROW function:
=ROW(reference)

If the LARGE function is what you were looking for there is another function SMALL(array,k) for the lower values in a range.

 

[gib6717]

Thanks all ray:
The max,min combo is going to work the best though
max (a1:a5) - min (a1:a5)
Thanks again...