<

Extracting unique values in Excel with the Unique function

Posted on
3,008 Points
8 Views
Last Modified:
Published
Experience Level: Intermediate
5:32
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.
0
Author:Bob Flisser
0 Comments
This article series will show you how to utilise the Next Generation Cryptography (CNG) API from Microsoft for modern hashing and encrypting/decrypting in VBA. In this part: Storing hashed or encrypted data.
On the official Microsoft website we can find out curious data about Excel. In this post, I will tell you about the ones that have caught my attention the most.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month