Serial Numbers for different categories

Dear All,

I am having different categories and I want to give Serial numbers for each category. For example there are categories AA, BB and CC. For each category I would like to give serial numbers like for AA starting from 1000 and for BB-2000 and CC-3000. (please refer the attached file for better understanding of the situation)

I want to do it using formula.

Any help appreciated.

Thanks,
aganesan99

Originally Posted by :) Sixthsense :)

In B2 Cell


=IF(COUNTIF($A$2:A2,A2)>1,VLOOKUP(A2,$A$1:B1,2,0)+COUNTIF($A$2:A2,A2)-1,COUNTIF($A$2:A2,A2)*(MAX($B$1:B1)+1000))


Drag it down...

Thanks Sixthsense. It worked. Great!!!!

aganesan99