View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
jase[_2_] jase[_2_] is offline
external usenet poster
 
Posts: 29
Default What function to determine the second small integer from a list?

Hi Tom,

if this said "=small(range,x)" then would there be a function that
could return the x value for a list of integers e.g =rank(range) ? or
would I have to come up with a UDF ?

Regards,
Jason Q

Tom Ogilvy wrote:
=small(range,2)

--
Regards,
Tom Ogilvy

"Eric" wrote in message
...
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