Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
User-Defined Function pre-empting Built-in Function? How to undo???? | Excel Programming |