I have a list of data in Excel in which I have successfully used the Sum(if(Frequency) formula when attempting to count unique values in one column. I now have a need to look at another column that I have ranked, and if the it meets a condition, I want to count the unique values in first column that contains duplication.
For example:
1st spreadsheet
Dept Rank
123 1
123 1
123 1
456 1
456 1
789 2
789 2
789 2
789 2
In the 2nd spreadsheet, I was able to count the unique numbers of departments (in the example there would be 3), but I cannot figure out how to count the unique values that fall within the rank. In the above example, I need to know that there were 2 unique values for department for rank 1 and one unique value for rank 2. Again, these results need to go into another spreadsheet where I am collecting values for reporting.
Start Free Trial
