What function to select the last 3 smallest integers?
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)
"Eric" wrote in message
...
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
"Bob Phillips" wrote:
=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
|