Assign sequence based on Unique Values

Question

I have the following list.&nbsp; I need to assign the "Market Split No" column but assigning a sequence based on the unique combination of Healthplan_Dashboard and Market Splits.&nbsp; So the combination of Alabama:Alabama gets 1 but the two combination of Alabama:Birmingham both gets 2.&nbsp;&nbsp; I think the best way would be to assign an index column that starts over at each change in Healthplan_Dashboard but I am not sure how to do that.&nbsp;Market Split NoHealthPlan_RegionHealthPlan_DashboardMarket SplitsGalaxySalesOffice1Southeast RegionAlabamaALABAMAALABAMA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2Southeast RegionAlabamaBIRMINGHAMBIRMINGHAM&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2Southeast RegionAlabamaBIRMINGHAMC. ALABAMA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3Southeast RegionAlabamaHUNTSVILLEHUNTSVILLE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3Southeast RegionAlabamaHUNTSVILLENO. ALABAMA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3Southeast RegionAlabamaHUNTSVILLENO.C ALABAMA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;4Southeast RegionAlabamaMOBILEMOBILE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;4Southeast RegionAlabamaMOBILES. ALABAMA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;5Southeast RegionAlabamaMONTGOMERYMONTGOMERY&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1West RegionArizonaARIZONAARIZONA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2West RegionArizonaPHOENIXPHOENIX&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3West RegionArizonaTUCSONTUCSON&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1Southeast RegionArkansasLITTLE ROCKLITTLE ROCK&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1Central RegionCentral TexasAUSTINAUSTIN&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2Central RegionCentral TexasSAN ANTONIOSAN ANTONIO&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1Central RegionClevelandCLEVELANDCLEVELAND&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1West RegionColoradoCOLORADOCOLORADO&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2West RegionColoradoDENVERDENVER&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3West RegionColoradoWYOMINGWYOMING&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1Central RegionColumbusCOLUMBUSCOLUMBUS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

vanessafvg · Accepted Answer

Anonymous&nbsp;
&nbsp;
would this work?
&nbsp;
i created a duplicated table, removed duplicates and created a index based on the composite columns and then merged that back in with a column called index
&nbsp;
see pbix attached

Forum Discussion

Assign sequence based on Unique Values

2 Replies

Related content

Sequencing Numbering within a Group Based off Unique Values

NULL assigned unique individual values

Assign to each unique value a number

Unique Count in Row convert

Priority Based Sales Rep Assignment

Market Split No	HealthPlan_Region	HealthPlan_Dashboard	Market Splits	GalaxySalesOffice
1	Southeast Region	Alabama	ALABAMA	ALABAMA
2	Southeast Region	Alabama	BIRMINGHAM	BIRMINGHAM
2	Southeast Region	Alabama	BIRMINGHAM	C. ALABAMA
3	Southeast Region	Alabama	HUNTSVILLE	HUNTSVILLE
3	Southeast Region	Alabama	HUNTSVILLE	NO. ALABAMA
3	Southeast Region	Alabama	HUNTSVILLE	NO.C ALABAMA
4	Southeast Region	Alabama	MOBILE	MOBILE
4	Southeast Region	Alabama	MOBILE	S. ALABAMA
5	Southeast Region	Alabama	MONTGOMERY	MONTGOMERY
1	West Region	Arizona	ARIZONA	ARIZONA
2	West Region	Arizona	PHOENIX	PHOENIX
3	West Region	Arizona	TUCSON	TUCSON
1	Southeast Region	Arkansas	LITTLE ROCK	LITTLE ROCK
1	Central Region	Central Texas	AUSTIN	AUSTIN
2	Central Region	Central Texas	SAN ANTONIO	SAN ANTONIO
1	Central Region	Cleveland	CLEVELAND	CLEVELAND
1	West Region	Colorado	COLORADO	COLORADO
2	West Region	Colorado	DENVER	DENVER
3	West Region	Colorado	WYOMING	WYOMING
1	Central Region	Columbus	COLUMBUS	COLUMBUS