So I have an array of numbers lets say
1
2
3
4
0
1
2
3
8
5
3
1
I would like to search and identify how many rows are from the lowest to the highest number?
So I have an array of numbers lets say
1
2
3
4
0
1
2
3
8
5
3
1
I would like to search and identify how many rows are from the lowest to the highest number?
Last edited by gannon_w; 10-27-2010 at 03:16 PM.
Assuming those values are in column A:
=MATCH(MAX(A:A), A:A, 0) - MATCH(MIN(A:A), A:A, 0) + 1
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Thanks that works.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks