Hello guys! I am currently doing a qualitative analysis of short comments. I have created a spreadsheet with comments as rows and categories (or 'codes') as columns; so that for the comment "I like ice cream and tea", I will tick the category "food" and "beveridge" ("ice cream" being included in the "food" category, and "tea" in "beveridge").
I am automatising the categorisation through keyword search, with the formula for the "food" column:
=(SUMPRODUCT(--ISNUMBER(SEARCH({"ice cream"};A1)))>0)
So that the cell returns TRUE when the keyword appears. It works well.
Now, I would like to create a column next to the comment column where the names of the categories would be written if an attached keyword appears in the comment. For instance, next to the comment "I like ice cream and tea", there would be a cell reading: "food - beveridge".
Does anyone have any idea how to do that? You would have my outmost gratitude and I'll send you some ice cream.
Have a good day!
Sylvain
I am automatising the categorisation through keyword search, with the formula for the "food" column:
=(SUMPRODUCT(--ISNUMBER(SEARCH({"ice cream"};A1)))>0)
So that the cell returns TRUE when the keyword appears. It works well.
Now, I would like to create a column next to the comment column where the names of the categories would be written if an attached keyword appears in the comment. For instance, next to the comment "I like ice cream and tea", there would be a cell reading: "food - beveridge".
Does anyone have any idea how to do that? You would have my outmost gratitude and I'll send you some ice cream.
Have a good day!
Sylvain