To assign serial number to unique value, the below formula may do you a favor:Įnter this formula: =IF(COUNTIF(A$2:A2,A2)=1,MAX(B$1:B1)+1,VLOOKUP(A2,A$1:B1,2,0)) into a blank cell beside your data, and then drag the fill handle down to the cells that you want to apply this formula, and the unique values have been ordered as following screenshot shown:ġ. To order the duplicate values, please apply the following formula:Įnter this formula: =COUNTIF($A$2:A2,A2) into a blank cell beside your data, and then drag the fill handle down to the cells which you want to apply this formula, and the cell values have been assigned based on the duplicate values, see screenshot: This article, I will talk about some simple formulas to help you solving this task in Excel.Īssign serial number to duplicate values with FormulaĪssign serial number to unique value with Formula If you have a list of values which contains some duplicates, is it possible for us to assign sequential number to the duplicate or unique values? It means giving a sequential order for the duplicate values or unique values as following screenshot shown.
How to assign serial number to duplicate or unique values in Excel?
