How to count number of individual values?

Copper Contributor
 

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?

 

mattisipola_0-1727867429436.png

 

Thank you.

3 Replies

@mattisipola 

In D2:

=IF(A2=A3, "", COUNT(UNIQUE(FILTER($B$2:$B$27, $A$2:$A$27=A2))))

Fill down.

@HansVogelaar It's not work

 

mattisipola_0-1727870198070.png

 

What I did wrong?

@mattisipola 

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