Insert text in Cell A1 based on keyword criteria
 

I want to populate cell A1 with specific text (the word "Active")
whenever the word "Yes" is found in cells A2:A20. Whenever the word
"Yes" is not found in cells A2:A20 I want to leave cell A1 blank.

Insert text in Cell A1 based on keyword criteria
 

wrote in message
oups.com...
I want to populate cell A1 with specific text (the word "Active")
whenever the word "Yes" is found in cells A2:A20. Whenever the word
"Yes" is not found in cells A2:A20 I want to leave cell A1 blank.

=IF(COUNTIF(A2:A20,"Yes")0,"Active","")
--
David Biddulph