How to count number of individual values?

Question

&nbsp;I want to count how many times the same value appears in a table column (Stamp Date) for the same person. Individual values ​​have been calculated manually. What would be a good way to implement this with formulas?&nbsp;&nbsp;Thank you.

hansvogelaar · Answer

mattisipola&nbsp;
In D2:
=IF(A2=A3, "", COUNT(UNIQUE(FILTER($B$2:$B$27, $A$2:$A$27=A2))))
Fill down.

mattisipola · Answer

HansVogelaar&nbsp;It's not work&nbsp;&nbsp;What I did wrong?

hansvogelaar · Answer

mattisipola&nbsp;
Do you use comma as decimal separator? If so, change all commas in the formula to semicolons i.e. ;

Forum Discussion

How to count number of individual values?

Share

Resources