Sorting out the number of unique and distinct values from a list across a column in an Excel sheet could be useful for many purposes. You might need to calculate the number of players who won a ...

Microsoft Excel is the go-to if you want to calculate a lot of data all at once, but even outside of basic math, you can use the app to find specific info.

Figure A Excel’s UNIQUE () function returns a list of unique names. UNIQUE ()retrieves the unique values and passes them to SORT (), which returns them in alphabetical order.

If you need to average a list of values in Microsoft Excel that contain duplicates without including the duplicates, don't fret over a complex expression when you can easily remove those duplicates.