Min Max function
 

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

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

Min Max function
 

On Mon, 3 Nov 2003 11:26:18 -0000, "jp" wrote:

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