Aug 16 2022 02:56 AM
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 |
Aug 16 2022 03:07 AM
SolutionAug 16 2022 03:07 AM
SolutionIn A2:
="01-"&LEFT(B2,2)&"-"&COUNTIF(B$2:B2,B2)
Fill down.