Hi,
I am looking for an array formula that can perform a running count of occurrences for items in a list and spill the results in a spill range. Until now I have been using the following Countif formula:
Apples | 1 |
Apples | 2 |
Bananas | 1 |
Peaches | 1 |
Grapes | 1 |
Apples | 3 |
Bananas | 2 |
Grapes | 2 |
Oranges | 1 |
Oranges | 2 |
Grapes | 3 |
Oranges | 3 |
Best regards,
Range Rover