abstract-background-of-multi-colored-cubes.jpg
News

Excel: How to count unique items in a list

Feb 01, 2023 · 7 min read

FREE ACCOUNT

ACCESS

When working with data, you often need to know how many unique items you have in a list. For example, you might wish to know how many customers you have in your database, how many products you can offer to distributors, or all the countries or geographical regions you make sales in.

The required data is frequently stored in tables or lists where duplication is rife. Therefore, how do you “retire” the replicants? Here, I consider three approaches, reviewing the

Already a member?

Log in with your account
 
Forgotten email
Forgotten password

Not a member?

To gain access to exclusive content, your first step is to join the AICPA & CIMA.

Mentioned in this article

Topics

Manage preferences

Related content

}