How to get unique values in a column in Excel

Want to get unique values in a column in Excel? This video will show you how. There are methods: the advanced filter will hide duplicated data while remove duplicates method will destroy repeated data which may or maybe not be what you want.

The advanced filter method should work from Excel version 2003 to present. The remove duplicates method should work from version 2007 to present.

If you have trouble understanding anything or it didn't work for, please let me know what you didn't understand or what version of Excel you're using. ... https://www.youtube.com/watch?v=Lf-7e5JKrwQ