Forum Discussion

Chelu13's avatar
Chelu13
Copper Contributor
Mar 12, 2022
Solved

Help me to find the function to do this (Count values with matching condition)

I have this data, and i want to count the numer of data that appears in the left (no counting same data [DISTINC]) for each number in the right column, and the most important, do the operation ...
BI & Data Analysis
excel
Formulas and Functions
office 365
  • OliverScheurich's avatar
    OliverScheurich
    Mar 12, 2022

    Chelu13 

    =COUNTA(UNIQUE(FILTER($A$1:$A$11,$B$1:$B$11=D1)))

    Is this what you are looking for? 

Chelu13's avatar
Chelu13
Copper Contributor
Mar 12, 2022
Thank you Quadruple_Pawn, exactly this is what i was looking for, i didn't think about counta, to count the spaces that are not in blank, so thank so much!!