Formula for Specialized Numbering (bullet style)

[bbrice714]

I apologize if this has been covered. I did quite a bit of research, but wasn't able to find anything that helped me (maybe I was using the wrong terminology).

I have a very large spreadsheet with a list of clients with several sub categories for each client. I need 2 formulas (preferably, no macros if i can avoid it):
1) one formula would be for one column where it numbers each client (331, 332 below), being able to skip rows and recognize when a new client occurs
2) the other formula would be for the next column over and would number each item for the client as a subcategory with the decimal separator format shown below (331.1, 331.2, etc.). this formula would need to be flexible to accommodate varying numbers of items for different clients.

i hope this makes sense. can anyone help? thank you in advance!

[TABLE="width: 323"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD="colspan: 2, align: center"]CLIENT NUMBER[/TD]
[TD]CLIENT NAME[/TD]
[/TR]
[TR]
[TD]331.[/TD]
[TD] [/TD]
[TD]CLIENT X[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]331.1[/TD]
[TD]ITEM for CLIENT X[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]331.2[/TD]
[TD]ITEM for CLIENT X[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]332.[/TD]
[TD] [/TD]
[TD]CLIENT Y[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]332.1[/TD]
[TD]ITEM for CLIENT Y[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]332.2[/TD]
[TD]ITEM for CLIENT Y[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]332.3[/TD]
[TD]ITEM for CLIENT Y[/TD]
[/TR]
</tbody>[/TABLE]

 

[bbrice714]

bump.

 

[bbrice714]

bump.

 

[bbrice714]

bump.