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

=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

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

On Sat, 31 Dec 2005 03:41:02 -0800, "Eric"
wrote:

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

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

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