View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default 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