xxxxxxxxxx
=SUM(--(LEN(UNIQUE(FILTER(B6:B15,(C6:C15=H6)*(D6:D15="june"),"")))>0))
xxxxxxxxxx
import pandas as pd
# Read the Excel file
df = pd.read_excel('path_to_excel_file.xlsx')
# Calculate the count of unique values in a specific column
unique_count = df['column_name'].nunique()
print("Unique count in Excel:", unique_count)