Skip to content
The Chat Archive
gpt-3.5-turbo-0613· OpenAI WildChat-4.8M (AI2)

command for excel column equal to 1 if column H contains "opening" phrase somewhere in…

  1. User

    command for excel column equal to 1 if column H contains "opening" phrase somewhere in its cell

  2. Assistant

    To mark a column as 1 if column H contains the phrase "opening" somewhere in its cell in Excel, you can use the following formula in the desired column:

    =IF(ISNUMBER(SEARCH("opening", H1)), 1, "")

    Here, H1 refers to the first cell in column H. You can adjust the cell reference as per your data structure.

    Copy and paste this formula into the first cell of the column where you want the result to be displayed. Then, drag the fill handle down to apply the formula to the remaining cells in that column.