I have a Google Sheet, with the first row container headers (so row references will be -1) and rows are "grouped" by every 7 rows. See below.

Example Google Sheet

I've manually typed the numbers into the Image # column, but is there a way to use a formula to enter in an incrementing number every 7 rows into that column so I don't have to it for 80+ unique Captions? I'm doing this to keep track of how many unique Caption rows there are.

1 Answer 1


Please try, 1 in A2 and in A3 copied down:

  • 1
    Brilliant! That worked like a charm. Thanks!
    – scferg5
    Jul 31, 2014 at 16:22

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.