excel count unique values code example

Example 1: how to count number of unique values in a column python

pd.value_counts(df.Account_Type)

Gold        3
Platinum    1
Name: Account_Type, dtype: int64

Example 2: excel count unique dates

=COUNT(UNIQUE(B5:B14))

Example 3: power bi count unique values in a column

=DISTINCTCOUNTNOBLANK('your_table'[your_column])