Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match with yes or no question
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match with yes or no question
=IF(ISNUMBER(MATCH(A2,CompareToList,0)),"yes","no" )
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Donald B" wrote in message ... 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match Question | Excel Worksheet Functions | |||
Match Question | Excel Worksheet Functions | |||
Match Lookup question | Excel Worksheet Functions | |||
Match or Index Question | Excel Worksheet Functions | |||
MATCH Question | Excel Worksheet Functions |