ExcelBanter - What function to determine the second small integer from a list?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - What function to determine the second small integer from a list? (https://www.excelbanter.com/excel-discussion-misc-queries/62426-what-function-determine-second-small-integer-list.html)

Eric

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

bpeltzer

What function to determine the second small integer from a list?

=small(range,2)

"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

All times are GMT +1. The time now is 12:00 AM.