Hi all, long time lurker, first time poster. Thanking you in advance.
I am attempting to do some analysis on calls into a call center and I have a large spreadsheet that contains a call category and call description. Essentially, what I want to do is search column A for 'Category X' and subsequently search the corresponding call description in Column B for a specific code. Then, if there is a match, I want to put the value '1' for a match in column C and '0' if not found.
Lets say column A contains three categories: i.e. Operations, Claims, Sales.
Lets say column B contains any random string of text: i.e. string of text is for code 0000, string of text is for code 0000, string of text is for the code 1111
So, say I want to search all the text in column B for the code '0000' where the category in column A is 'Operations' and subsequently put the value 1 in the corresponding cell in column C.
How would I go about doing this?
I am attempting to do some analysis on calls into a call center and I have a large spreadsheet that contains a call category and call description. Essentially, what I want to do is search column A for 'Category X' and subsequently search the corresponding call description in Column B for a specific code. Then, if there is a match, I want to put the value '1' for a match in column C and '0' if not found.
Lets say column A contains three categories: i.e. Operations, Claims, Sales.
Lets say column B contains any random string of text: i.e. string of text is for code 0000, string of text is for code 0000, string of text is for the code 1111
So, say I want to search all the text in column B for the code '0000' where the category in column A is 'Operations' and subsequently put the value 1 in the corresponding cell in column C.
How would I go about doing this?