اكسل

Ever wanted to get distinct count in Excel? You can use Pivot Table to get the answer quickly. Something like this:

Here is a simple trick to add distinct count to Excel pivot tables quickly.

Let’s say you have data like this:

As you can see, several products are repeated on each day. When you make a pivot table from this data and add product count, Excel counts all products. But we want to see just the distinct count (ie if there is a duplicate product in a day, we want to count it just once). To get distinct count in the pivot table,