Home >Tips >Unique values kalmstrom.com site map icon Site map  

Find Unique Values in Excel

An Excel tutorial by Peter Kalmstrom

Excel iconIn the demo below Peter Kalmstrom has imported a lot of data from another system into Excel and wants to find all unique values in one of the columns.

This is the process:
  • Fit the column width to the content to get a better overview of data.
  • Remove any empty columns or rows.
  • Format the datasheet as a table.
  • Summarize the table with a Pivot Table in a new sheet.
  • Drag the column you want to find unique values in to ROWS.
  • Now you can see all the unique values.

Peter uses Excel 2013 for his demo, but finding unique values this way is possible in earlier versions too.

Products Buy FAQ Services Tips Services Books Contact About Us Tools

Security and integrity

Copyright  Kalmstrom Enterprises AB  All rights reserved