Count Distinct values using UNIQUE and COUNTIF Functions

preview_player
Показать описание
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
Рекомендации по теме
Комментарии
Автор

ugg I cannot the purpose of this video (final formula) cos of the big logos at the end :(

Nazawazza