Count Distinct values using UNIQUE and COUNTIF Functions
Use COUNTIF, one of the statistical functions, to count the number of cells that meet a criterion; for example, to count the number of times a particular city appears in a customer list.
The UNIQUE function returns a list of unique values in a list or range. The UNIQUE Function in new to Excel and is available in Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web Excel 2021 Excel 2021 for Mac Excel for iPad Excel for iPhone Excel for Android tablets Excel for Android phones