Create Unique List from Data Entry

How to create unique list from data entry in excel?

1. In Excel, Go to Data > Filter > Advanced Filter
2. Choose under Action : Copy to another location
   
3. Select your data entry where you want to create unique in list range
4. Choose Copy to in column B
5. Check list Unique records only, then click OK
   

Have Fun! :)