Hello All, How do I create an auto numbering system based on a value in another column?

Sunny Singh

The item number used more than one item should have increasing sequence numbering pattern. for example 8540-0001 line one should have seq #1 and on line at used again should have seq # 2.

DKazatsky2

Hi @Sunny Singh,

Give this a try in the 1st row and drag down, you cannot turn this into a column formula. New rows should still continue to have the formula moving forward.

=COUNTIF([ITEM NUMBER]$1:[ITEM NUMBER #]1, [ITEM NUMBER]@row)

Hope this helps.

Dave

DKazatsky2

Hi @Sunny Singh,

Give this a try in the 1st row and drag down, you cannot turn this into a column formula. New rows should still continue to have the formula moving forward.

=COUNTIF([ITEM NUMBER]$1:[ITEM NUMBER #]1, [ITEM NUMBER]@row)

Hope this helps.

Dave

Sunny Singh

Thanks Dave it worked