Thread: fill down formula incrementing by every 12 rows
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Westy Westy is offline
external usenet poster
  
Posts: 11
Default fill down formula incrementing by every 12 rows
Hi - I want to drag/fill down a formula in 12 rows (eg A1 to A12)as follows
=Sheet1A2
=Sheet1A2
=Sheet1A2
=Sheet1A2
=Sheet1A3
=Sheet1A3
=Sheet1A3
=Sheet1A3
I want it to increment by 1. eg next 12 rows would =Sheet1A4 etc
Selecting the entire range does not work, it just keeps returning the same
value eg Sheet1A2
Thanks
Craig
Reply With QuoteReply With Quote