Forum Discussion
Solved
Number of occurrences of a particular item in sequence.
Hi ...
Looking for a formula to list down the number of occurrence of a particular item and suffixing it with the time it is repeated. Eg. given below. I had tried using countA function but it returns only the total number of instances of the item.
Please help to solve.
| CODE | ITEM |
| 01-AP-1 | APPLE |
| 01-BE-1 | BERRY |
| 01-BA-1 | BANANA |
| 01-AP-2 | APPLE |
| 01-OR-1 | ORANGE |
| 01-KI-1 | KIWI |
| 01-BE-2 | BERRY |
| 01-AP-3 | APPLE |
| 01-BA-2 | BANANA |
