Extracting unique values in Excel with the Unique function

Posted on
3,008 Points
Last Modified:
Experience Level: Intermediate
Bob Flisser
Bob Flisser has authored many courses and books about Microsoft, Adobe and Apple products, and has been a computer trainer since the 1980s.
Between the Sheets podcast, episode 1

Excel’s unique function will generate a list of all unique values in a range. For example, if you have a column that has “chocolate” listed five times, “vanilla” listed four times, and “mango” listed six times, unique will generate a list of three items: chocolate, vanilla, and mango. The function can also work across multiple fields to consider them as one.
Author:Bob Flisser
Windows Explorer lets you open archive (tar and tgz) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating archive files takes a little more - and that you'll find here.
The Indian number format for currency has groups of two and three digits. The native Format function of VBA cannot handle this if Windows is set for a Western localisation. Thus, a custom method must be applied. Here it will be shown how to use dyna…

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month