Assign Serial Numbers to each product code

Hello,

I need you valuable support.
I have to assign a serial number to each product code organized in an excel table. The products are found in the table in more than 1 row. Each product belongs to a specific category of label format. What I need is: to assign a serial number to each product, serials should start from 1 and increase sequentially. Once the Label Category changes, the serial should start from 1 within that category.

Thank you in advance!
Edlira from Albania

Try this in E2 and committed with Ctrl+Shift+Enter

Please Login or Register  to view this content.

Thank you! It seems ok, but what if the data are in a table, so how can I replace cells reference with table range, where A=[ProdCode], C=[Printing Category]

Thank you so much, Glenn! It works perfectly. This is saving me a lot of time and overload work. Thank you again!
Respectfully,
Edlira