Hello again - I need some more help!
I have 20,000+ rows of data with 4 columns. The columns represents attempts that I'm trying to quantify if they were successful or not. There are various text strings that can be in these cells, but the ones I am interested in all start with "Call".
My goal is to put a column to the right of my data with a "yes" if any of the 4 columns per row contain "Call" and a "No" if none of them do.
I'm thinking that I can just sort 3 of the columns alphabetically and do it sort of manually that way, but I'm wondering if there is a formula that could make this work. If so, I'm assuming it would be a very long "or" statement, or I would need to do a search for a string formula for each of the 4 columns independently, and then do another forumula to see if any of those 4 have a "yes" in them.
If sorting and doing it manually is easier, I'll just do that. Thanks.
I have 20,000+ rows of data with 4 columns. The columns represents attempts that I'm trying to quantify if they were successful or not. There are various text strings that can be in these cells, but the ones I am interested in all start with "Call".
My goal is to put a column to the right of my data with a "yes" if any of the 4 columns per row contain "Call" and a "No" if none of them do.
I'm thinking that I can just sort 3 of the columns alphabetically and do it sort of manually that way, but I'm wondering if there is a formula that could make this work. If so, I'm assuming it would be a very long "or" statement, or I would need to do a search for a string formula for each of the 4 columns independently, and then do another forumula to see if any of those 4 have a "yes" in them.
If sorting and doing it manually is easier, I'll just do that. Thanks.