Got a whole bunch of data in a row or column that needs to be sorted alphabetically? You can do it with just a few clicks in Excel.

Again, in the absence of any optional arguments, the data is sorted in alphabetical order according to the values in the left-hand column by default, and there's a handy total row at the bottom.

Figure B How to use the UNIQUE () function in Excel If you’re using Microsoft 365 or one of the 2019 standalone versions of Excel, you can quickly create a dynamic list using the UNIQUE () function.

Learn how to extract specific data from Excel cells using formulas, tools, and techniques to clean and organize messy datasets.