Forum Discussion

mystiqdreamer's avatar
mystiqdreamer
Copper Contributor
Oct 06, 2021

Using COUNTIF to match a String in a StringArray to a list

Right now, I have a list of keywords on one sheet, and on another sheet I have a few columns dedicated to the names of majors. My current conditional formula will fill the majors cells green if: COUN...
excel
Formulas and Functions
mystiqdreamer's avatar
mystiqdreamer
Copper Contributor
Oct 06, 2021

Detlef_Lewin That's what I've done in the meantime; I copy/pasted the majors that popped up into my list so the function would detect them. Only thing about that is when I reach new majors that I want as part of the desirable list, they'd have to be manually entered as well, rather than having a portion of it be auto-detected by what I'm looking for. Doing it manually isn't so inconvenient, but it does suck as I have 50+ more colleges to research and some majors are technically the same but called slightly different things.

 

It's definitely an option that solves the problem, but it doesn't satisfy my c#-code-brain thinking :'3 Thanks for the suggestion.

Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Oct 06, 2021

mystiqdreamer 

It's probably possible to create such a formula but it is also probable that there will be problems ahead: false positives/negatives or different delimiters.

So you might still end up editing your list of desirable majors.