Min Max function

[jp]

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

 

[Paul B]

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 **

 

[Ron Rosenfeld]

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.

Look at HELP for the SMALL and LARGE worksheet functions.


--ron