Forum Discussion

Ber93's avatar
Ber93
Brass Contributor
Feb 16, 2022
Solved

Count number of occurrences only once

Good afternoon   I have a column where values are repeated many times. I need to count the occurrences of each value in another column, so I was thinking to use COUNTIF, but if I extend COUNTIF ove...
  • OliverScheurich's avatar
    Feb 16, 2022

    Ber93 

    =IF(COUNTIF($CL$1:CL2,CL2)>1,"",COUNTIF($CL$1:$CL$1000,CL2))

    Maybe with this formula.

Resources