2

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.

3

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

=if(mod(row(),7)=2,A2+1,A2)
  • 1
    Brilliant! That worked like a charm. Thanks! – scferg5 Jul 31 '14 at 16:22

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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