Forum Discussion

AdLTFL's avatar
AdLTFL
Copper Contributor
Aug 08, 2022
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 to be 1, as they have only raised 1 Invoice for Client 10 instead of it showing as 4.

Thanks for your help 🙂

 

  • AdLTFL 

     

    =COUNT(UNIQUE(FILTER(Sheet2!$A$2:$A$9,Sheet2!$B$2:$B$9="EM","")))

     

    Adjust the ranges as needed.

1 Reply

  • AdLTFL 

     

    =COUNT(UNIQUE(FILTER(Sheet2!$A$2:$A$9,Sheet2!$B$2:$B$9="EM","")))

     

    Adjust the ranges as needed.

Resources