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)))
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.
