Nov 24 2022 06:21 AM
Hi
I am trying to determine if a text value is within a cell and if so record result as a “Yes” within another cell.
For example I have text in my tag column D that is comma separated. As an example: (Act, Databases) are within a cell. I wanted a formula to search the column D for “Databases” and add a Yes within another cell.
can you help me?
Nov 24 2022 06:52 AM
Nov 24 2022 06:53 AM
You can use the following formula if the entry you want to search is in cell A1.
=ISNUMBER(FIND("Databases",A1))
Nov 24 2022 07:57 AM
Nov 24 2022 07:59 AM