I have a lot of data in a column. I want to use the data from cells on every 7th row, so I want to reference cells in every 7th row.
My first reference is "=P8"
If I copy that cell and paste it below, I get "=P9", but I want it to be "=P15".
I have tried "=P8+7" and "=P(8+7)" and variations but they give errors such as #VALUE! or #NAME!
I think the solution may be simple, but my mind is a blank!
Thanks for any help you can give.
- Baht