I have a complicated excel question which has been frying my brain for hours...
I have 447 rows of text in column A, I want to increase the number in column B by 1 every 447 rows and then repeat until the number reaches 250.
For example:
Apple, 1
Pinapple, 1
Cheese, 1
Apple, 2
Pinapple, 2
Cheese, 2
Apple, 3
Pinapple, 3
Cheese, 3
Any ideas?
Bookmarks