Forum Discussion

saemi95's avatar
saemi95
Copper Contributor
Aug 11, 2021
Solved

COUNT unique values only in FILTERED dataset

  Hi!    I have a dataset that in principle looks like this (I have attached the file).      I have to divide the value in one cell (column B) by the number of UNIQUE values in one column...
excel
office 365
  • JMB17's avatar
    JMB17
    Aug 11, 2021
    Perhaps you can use the filter function:
    =B2/COUNTA(UNIQUE(Filter($C$2:$C$31, $A$2:$A$31=A2)))
JMB17's avatar
JMB17
Bronze Contributor
Aug 11, 2021
Perhaps you can use the filter function:
=B2/COUNTA(UNIQUE(Filter($C$2:$C$31, $A$2:$A$31=A2)))
  • saemi95's avatar
    saemi95
    Copper Contributor
    Aug 11, 2021
    Thanks! You are right, this works perfectly.

Resources