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
Watch video How to get a distinct count of unique values in Excel online without registration, duration hours minute second in high quality. This video was added by user Nate Chamberlain 22 September 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 8,312 once and liked it 20 people.