(1) Check Copy to another location option and Unique records only option In the Advanced Filter dialog, do as below: In Excel, you can apply the Advanced Filter function to filter out the unique data from a list.ġ. Quickly create unique list from column with Kutools for Excel Suppose you have a list of names with duplicates, and now you want to create a new list of unique names from this given column, how could you solve it in Excel? Now this tutorial introduces some tricks that can help you quickly create a unique list from a give column.Ĭreate unique list from column with Advanced Filter How to quickly create unique list (remove duplicates) from a given column in Excel?
0 kommentar(er)
