CODEWITHSUNDEEP
excelexcel-formula
niki b
niki b

Reputation: 989

Excel Auto Numbering with Levels based on other columns

tried google to no avail. Can someone help with the Excel Formula so that I can achieve this number formatting? Thanks in advance!

A. ColC = ColA + "." + auto number. Example, if ColA = 3, then ColC = 3.1, 3.2, etc.

B. ColE = ColC + "." + auto number. Example, if ColC = 3.2, then ColE = 3.2.1, 3.2.2, 3.2.3

By auto number, I mean if I add a row, then the value is the next number value for that column (something similar to what Word does).

enter image description here

Upvotes: 1

Views: 2445

Answers (1)

user35183
user35183

Reputation: 26

You can use a count for that pourpose Assuming the column is b do

=b1&"."&countif($b$1:b1,b1)

Upvotes: 1

Related Questions