How do I get the distinct/unique values in a column in Excel?

"Simpler than you might think:

Click the Data Ribbon Menu
Select the Advanced Button in the Sort & Filter section
Fill in the dialog Box, copying the results to another location and making sure you tick Unique records only"

"Or (a simple crude way):

In B1,

=IF(COUNTIF(A$1:A1,A1)=1,A1,"""")

and copy down. It just copies the first occurrence of each value across (in the row that it occurs in)."

"For me, the most simple way to sort is to use ""Filter"" option.

First step is to find the duplicate values with Conditional Formatting -> Highlight Cells Rules -> Duplicate Values.

Then click the arrow on the Column you have the duplicates (in this case ""Platforms"") -> Filter by Color (Cells color or font color)."
"For me, the most simple way to sort is to use ""Filter"" option.

First step is to find the duplicate values with Conditional Formatting -> Highlight Cells Rules -> Duplicate Values.

Then click the arrow on the Column you have the duplicates (in this case ""Platforms"") -> Filter by Color (Cells color or font color)."

In Excel 365 we now have UNIQUE(), which returns an array of unique rows.