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 ...
For example:
=UNIQUE(FILTER(D3:D1000,(D3:D1000<>"")*(COUNTIFS(D3:D1000,D3:D1000,E3:E1000,"*Eval*")=0)))
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.
- The error is likely mine, I defined name as the full range in column D, and the output included all unique names present in the list, whether "eval" was adjacent in column E or not.