Hi all,
Using an already existing spreadsheet with 10,000 columns of data.
In the first column it has the names of items but multiple times (ex: item1, item1, item2, item2, item2, item3, item3, item3, item3, etc.)
I would like a way to create the sequential numbers in another column. In regards to the example.
Item1 returns 1
Item1 returns 2
Item2 returns 1
Item2 returns 2
Item2 returns 3
Item3 returns 1
Item3 returns 2
Item3 returns 3
Item3 returns 4
Is there a route to take to do this auto-numbering per the column data? Please message me with any questions your assistance is much appreciated!
Thanks
Bookmarks