How to get a distinct count of unique values in Excel
If you're wanting to get the distinct count of unique items within a cell range or table column in Microsoft Excel, this video will help you out.
Essentially we use two funcitons to get distinct count. UNIQUE helps us get an array, or list, of the unique values within our selected range or column.
COUNTA helps us count the items returned by using UNIQUE.
Used together, we can get the distinct count of unique values for any cell range or column in Excel by using =COUNTA(UNIQUE([ColumnName])). Be sure to watch all of the video to learn how this can vary based on where you are placing the formula, and the data from which you're wanting to derive a distinct count value.
Related blog post: https://natechamberlain.com/2022/09/2...
Subscribe to this channel: https://bit.ly/3fWYhZQ
Donate to help support: https://bit.ly/3AE3M99
LinkedIn: / nchambe
Website: https://NateChamberlain.com
Смотрите видео How to get a distinct count of unique values in Excel онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Nate Chamberlain 22 Сентябрь 2022, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 8,312 раз и оно понравилось 20 людям.