What function to select the last 3 smallest integers?

E

Eric

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
 
B

Bob Phillips

=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)
 
E

Eric

Thank you for your reply, it works on cell, but when I try it on conditional
formating, this does not work. Do you know how to make it work for
conditional formating?
Thank you very much
Eric
 
R

Ron Rosenfeld

Thank you for your reply, it works on cell, but when I try it on conditional
formating, this does not work. Do you know how to make it work for
conditional formating?
Thank you very much
Eric
Click to expand...

If you go look in the thread where you originally posted this problem, you
would find an answer that may work.

Posting the same problem in multiple threads generally leads to fragmentation
and more difficulty in obtaining an answer.

--ron
 
B

Bob Phillips

You didn't mention conditional formatting!

Assuming the given list is in A1:A9 and the given numbers are in L1:L3,
select L1:L3 and apply the formula in CF

=ISNUMBER(MATCH(L1,SMALL($A$1:$A$9,ROW($1:$3)),0))

--

HTH

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