View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
 
Posts: n/a
Default 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.