View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jp jp is offline
external usenet poster
 
Posts: 15
Default 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