E
E
Eugene Dragan2021-04-27 00:36:32
Google Sheets
Eugene Dragan, 2021-04-27 00:36:32

How to count the number of repetitions in front of each company?

How to count the repetitions in front of each company, namely, what is the number of repetitions? A document with a ready-made example of what I want to implement, for clarity:

Example document

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Alexander Ivanov, 2021-04-27
@dragan2011

Maybe,

=ARRAYFORMULA(IF(A3:A100<>"";MMULT(
  (ROW(A3:A100)>=TRANSPOSE(ROW(A3:A100))) *
    (A3:A100=TRANSPOSE(A3:A100))^1;
  ROW(A3:A100)^0
);))

60877f145ef43240259991.png
See examples Performing Cumulative Calculations. Check

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question