I have a series in 8 columns that I want to reflect a calculation of 8 columns divided by a number. The sheet looks like this:
1 A B C D E F G H J K L M N O P Q
2 2 4 6 8 10 12 14 16 4 8 12 16 20 24 28 32
3
4
5 10 40 60 80 300 500 560 600
The data in columns J-Q are every 16 rows but I want the calculations in A-H done with no spaces between rows. Everytime I try to autofill the result is that it doesn’t skip every 16 rows and its calucating rows with no data. Is there a way to autofill this or do I have to insert the cell reference from each column J-Q into the A-H?
LeroyG added preformatted text code.