Skip to main content
1 of 2
Martín
  • 1.4k
  • 2
  • 4
  • 7

Try with;

=BYROW (A2:A,LAMBDA(each,IF(each="","",COUNTA (FILTER(A2:each,each)))))
Martín
  • 1.4k
  • 2
  • 4
  • 7