Use worksheet function UNIQUE from Excel 365 onwards
http://www.sulprobil.com/sbuniq_en/
Last updated 2 years ago