View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default What function to select the last 3 smallest integers?

=ISNUMBER(MATCH(3,SMALL(A1:A9,{1,2,3}),0))

where A1:A9 holds the list of numbers


--

HTH

RP
(remove nothere from the email address if mailing direct)


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