View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dr. S[_2_] Dr. S[_2_] is offline
external usenet poster
 
Posts: 1
Default dynamic cell number

copying and pasting a function down a column will increase the cell number by
one in each row (example =A1+6, and below: =A2+6 and below =A3+6 etc.) Is it
possible to make that calculation for every 4th row and list the results
directly in a column. Or asked differently is ther any way to increase the
cell number by a different value, by 4 for instance? (=A1+6 will be followed
by =A5+6 and then =A9+6.