How do I get the distinct/unique values in a column in Excel?
Fresh3 days ago
Mar 15, 20261065966 viewsConfidence Score1%
1%
Problem
If I have a column with values, and I want to find out what distinct values are in there (not how many - but the actual distinct values), how can I do that? In SQL Server I would do something like
Error Output
SELECT Distinct(MyColumn) FROM MyTable
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: How do I get the distinct/unique values in a column in Excel?
Low Risk
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
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix