Extract Unique Values that do NOT Contain...

Hi

I would be grateful for some help.

Attached is a sample spreadsheet with a list of names. I am trying to extract list from the names in Column A that do not contain a certain text string. I am extract a list of names that have name Andy in it for example, but want to extract a list of names that do not contain Andy. I have tried FIND("<>*Andy*"), but doesnt work.

Any help would be appreciated..

Thanks

Nick

Formula in D2:

=IFERROR(INDEX(List,MATCH(,IF(ISERR(SEARCH(B$2,List)),COUNTIF(D$1:D1,List)),)),"")



Array formula: Press Ctrl+Shift+Enter, not just Enter

Copy down