Feb 16 2022 03:45 AM
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 over the entire column, the occurrences of each value will be counted each time the value appears. I need each value's occurrences to be counted only once, like shown in the example screenshot
Feb 16 2022 03:52 AM
SolutionFeb 16 2022 03:52 AM
Solution=IF(COUNTIF($CL$1:CL2,CL2)>1,"",COUNTIF($CL$1:$CL$1000,CL2))
Maybe with this formula.