Match with yes or no question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Donald B - 13 Jun 2007 03:41 GMT

Hi All - I've looked all over for the answer to this question but. ..:(

I have a list of names that appear multiple times that I need to match with
a "YES".

This list also contains names I want to ignore. l would like to put a "yes"
on the ones I want to keep (no matter how many times it aappears) and "no" on
the ones to ignore.
TIA -- Donald

Reply to this Message

Bob Phillips - 13 Jun 2007 09:45 GMT

=IF(ISNUMBER(MATCH(A2,CompareToList,0)),"yes","no")

Signature

HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

> Hi All - I've looked all over for the answer to this question but. ..:(
>
[quoted text clipped - 8 lines]
> the ones to ignore.
> TIA -- Donald

Reply to this Message