The Best Office Productivity Tools Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80% How to count same or duplicate values only once in a column? How to count unique values in a filtered column in Excel? How to count the number of unique values in a range in Excel? Then drag the fill handle down to get the unique values of the corresponding criteria. Note: In the above formula: A2:A18 is the column data that you count the unique values based on, B2:B18 is the column that you want to count the unique values, D2 contains the criteria that you count unique based on.Ģ. And then press Ctrl + Shift + Enter keys together to get the correct result, see screenshot: To solve this problem, the following formula can help you, please do as follows:ġ.
For example, I have the following two columns data, now, I need count the unique names in column B based on the content of column A to get the following result:Ĭount unique values based on another column with array formula
It may be common for us to count unique values in only one column, but, in this article, I will talk about how to count unique values based on another column.
0 kommentar(er)
