SOLVED

Number of occurrences of a particular item in sequence.

Contributor

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.

CODEITEM
01-AP-1APPLE
01-BE-1BERRY
01-BA-1BANANA
01-AP-2APPLE
01-OR-1ORANGE
01-KI-1KIWI
01-BE-2BERRY
01-AP-3APPLE
01-BA-2BANANA
1 Reply
best response confirmed by Rudrabhadra (Contributor)
Solution

@Rudrabhadra 

In A2:

="01-"&LEFT(B2,2)&"-"&COUNTIF(B$2:B2,B2)

Fill down.