Forum Discussion
Solved
Count Values in another sheet but avoid duplicates
Hi, So in Sheet 1, I want to count the value 'EM' from Sheet 2 but avoid duplicate counting. In Sheet 2 I have some client numbers and initials. I want to be able to count 'EM' but the value t...
=COUNT(UNIQUE(FILTER(Sheet2!$A$2:$A$9,Sheet2!$B$2:$B$9="EM","")))
Adjust the ranges as needed.
=COUNT(UNIQUE(FILTER(Sheet2!$A$2:$A$9,Sheet2!$B$2:$B$9="EM","")))
Adjust the ranges as needed.