In the workbook attached, column C contains some numbering while D contains items being numbered. What would be the formula that would automatically introduce the next number in column C when the next item is introduced in column D?
Also, is there a way to to push down the total and the average as more items are added without inserting new rows?
Thank you.
Auto Numbering.xlsx
Bookmarks