Insert text in Cell A1 based on keyword criteria

  • Thread starter Thread starter twlove
  • Start date Start date
T

twlove

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.
 
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.
Click to expand...

=IF(COUNTIF(A2:A20,"Yes")>0,"Active","")
 
Back
Top