Min Max function
JP, have a look at large and small in help, something like this
=LARGE(A2:A10,2), =SMALL(A2:A10,3)
--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **
"jp" wrote in message
...
In a list of values MAX will identify the largest and MIN not surprisingly
will show the smallest.
Is there a function or routing for finding the next smallest or largest
e.g.
1 MIN
2 ? = Min +1
2 ? = Min +1
3
4
5
6
6
7
8 ?
8 ?
10 MAX
Thanks
John
|