Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What function to select the last 3 small values from a list ?
Does anyone know how to select the last 3 small values from a list? such as
a list {1,2,3,4,5,6,7,8,9} then reture the last 3 small value {1,2,3} Thank you for any suggestion Eric |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What function to select the last 3 small values from a list ?
=SMALL({2,3,4,5,6,7,8},{1,2,3}) will return an array of the three smallest
values. "Eric" wrote: Does anyone know how to select the last 3 small values from a list? such as a list {1,2,3,4,5,6,7,8,9} then reture the last 3 small value {1,2,3} Thank you for any suggestion Eric |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What function to select the last 3 small values from a list ?
Thank you for your suggestion.
I would like to go further ... Does it have a single function to perform the similar task? Given Lists {1,2,3,4,5,6,7,8,9} Given number {2,3,7} Condition: If any given number equals to any last 3 small integers, such as {1,2,3} in this case, then TRUE. 2 is TRUE 3 is TRUE 7 is FALSE Does anyone have any idea? Thank you Eric "bpeltzer" wrote: =SMALL({2,3,4,5,6,7,8},{1,2,3}) will return an array of the three smallest values. "Eric" wrote: Does anyone know how to select the last 3 small values from a list? such as a list {1,2,3,4,5,6,7,8,9} then reture the last 3 small value {1,2,3} Thank you for any suggestion Eric |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What function to determine the second small integer from a list? | Excel Worksheet Functions | |||
Error Handling #N/A with AVERAGE Function - Average of values in Row | Excel Worksheet Functions | |||
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 | |||
Function to list values of last 3 non-blank cells in a vertical bl | Excel Worksheet Functions |