Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What function to determine the second small integer from a list?
I get a list of integers, and would like to determine which one is the second
small integers from the list. Does anyone know what function to perform the above task? Thank for any suggestion Eric |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What function to determine the second small integer from a list?
Eric, If your list is A1:A10 =SMALL(A1:A10,2) This gives the second smallest number in the range. Cheers, Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=496933 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What function to determine the second small integer from a list?
=Small(list,2)
If the number that is the smallest in the list appears twice or more, you'll get the that number "Eric" wrote: I get a list of integers, and would like to determine which one is the second small integers from the list. Does anyone know what function to perform the above task? Thank for any suggestion Eric |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What function to determine the second small integer from a lis
Thank everyone, This is perfect for my needs
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to make an input in one column determine dropdown list in anot | Excel Worksheet Functions | |||
In Excel, can a function yield a drop-down list? | Excel Worksheet Functions | |||
no show all function in dropdown list in Pivot Table | Excel Discussion (Misc queries) | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
how to use the Prob function in a list of averages to find the le | Excel Worksheet Functions |