Min Max function

  • Thread starter Thread starter jp
  • Start date Start date
J

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
 
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 **
 
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.
Click to expand...

Look at HELP for the SMALL and LARGE worksheet functions.


--ron
 
Back
Top