Forum Discussion
Solved
Newbie Formula Question: Produce List of Unique Names from Column A Based on text from Column B
Suppose I have:
I would like to output a list of unique names from column D who DO NOT have the specific text "Eval" adjacent in column E.
I've attempted to adapt some formula examples found in this forum, but I don't know the language well enough to change the values, or really look up my issue.
Please advise.
For example:
=UNIQUE(FILTER(D3:D1000,(D3:D1000<>"")*(COUNTIFS(D3:D1000,D3:D1000,E3:E1000,"*Eval*")=0)))
Try this one:
=LET( NoEval, FILTER(name, ISERR(SEARCH("eval", ApptReason))), UNIQUE(NoEval) )- Thank you for your help, it seems this formula outputs a list of patients who have had evaluations vs. those who have not.
- That's odd. It works for me without issue.
For example:
=UNIQUE(FILTER(D3:D1000,(D3:D1000<>"")*(COUNTIFS(D3:D1000,D3:D1000,E3:E1000,"*Eval*")=0)))
Use =INDEX(UNIQUE(FILTER(D3:F1000,ISNUMBER(SEARCH("eva",F3:F1000)))),,1)
Please consider giving it a 'thumbs up' if it was helpful for you. (external links removed by moderator)
- Thank you for your time, this formula output a list of unique names but appears to have pulled each unique name, as opposed to the unique names that had "eval" in the adjacent column.
