I have a list for example...

Ian
Andy
John
David
Ian
Andy
John
David
Max

I want to search or filter the list and find the only non matched record in the list and put this in another sheet ie max as this is the only unique name in the list, all the others are matched. Everything I have tried eg filter for unique records returns ian andy john david max, which is not what I want. Any help appreciated.