CODEWITHSUNDEEP
excelexcel-formulaexcel-2007vba
Linga
Linga

Reputation: 955

Generating serial no based on two criterias

I have Prod_ID which is unique and description which will be same for different prod_ID. I need to generate serial no like Group 1, Group 2 based on both criteria . Serial no should be unique for one prod_ID & description. Is there any formula or macro to do this asap, because i have 50,000 + rows.

Serial	ID	Description
Group 1	30-0661	Medium
Group 1	30-0661	Medium
Group 1	30-0661	Medium
Group 1	30-0661	Medium
Group 2	30-0661	Narrow
Group 2	30-0661	Narrow
Group 2	30-0661	Narrow
Group 3	30-0661	Wide
Group 3	30-0661	Wide
Group 3	30-0661	Wide
Group 3	30-0661	Wide
Group 3	30-0661	Wide
Group 4	30-0661	Extra Wide
Group 4	30-0661	Extra Wide
Group 4	30-0661	Extra Wide
Group 4	30-0661	Extra Wide
Group 4	30-0661	Extra Wide
Group 5	30-0662	Medium
Group 5	30-0662	Medium
Group 5	30-0662	Medium
Group 5	30-0662	Medium
Group 5	30-0662	Medium
Group 5	30-0662	Medium
Group 5	30-0662	Medium
Group 5	30-0662	Medium
Group 6	30-0662	Narrow
Group 6	30-0662	Narrow
Group 6	30-0662	Narrow
Group 6	30-0662	Narrow
Group 6	30-0662	Narrow
Group 6	30-0662	Narrow
Group 6	30-0662	Narrow
Group 6	30-0662	Narrow

Upvotes: 0

Views: 88

Answers (1)

Gordon K
Gordon K

Reputation: 824

Highlight your ID and description columns and go to the data tab on the ribbon and select Advanced in the Sort & Filter section.

Choose Copy to another location, tick the Unique records only box, select somewhere to the right of your data as the Copy to location and press OK.

This will give you a set of all the combinations which can then be numbered sequentially.

Upvotes: 1

Related Questions