Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.
Quote from TheDudeDisplay MoreTry this...
Click and drag the bottom right corner of a cell or group of cells and drag them to the preferred location.
ah, just realized what you are saying... Could you repost a sample of the problem? I only see a string of dates on your current sample.
regards,
-Dude
Of course, in the sheet Extraction is where the source data is located. In the sheet Extraction offset is where the data should be displayed in from range a3 downwards.
Cheers
Robert
Re: Sum Across As Formula Dragged Down
In A4 of Sheet Extraction offset
=OFFSET(Extraction!$C$1,0,ROW()-3,1,1)
Copy down.
Re: Fill/Copy Formula Down But Increment Across
Other than Google and this forum, perhaps our half price complete Excel course? Link in auto email notifications. http://www.ozgrid.com/Services/halprice.htm
Don’t have an account yet? Register yourself now and be a part of our community!
