I am trying to copy a formula, the series goes like this
=Max(C1:F7)
=Max(C7:F13)
=Max(C13:F19)
=Max(C19:F25)
and so on.
Is there a way to "copy" this?
I am trying to copy a formula, the series goes like this
=Max(C1:F7)
=Max(C7:F13)
=Max(C13:F19)
=Max(C19:F25)
and so on.
Is there a way to "copy" this?
Last edited by jimbob; 10-11-2011 at 08:13 AM.
No but you can use a different approach.
Assuming you start in G1, you can use:
and then copy down.Please Login or Register to view this content.
That doesn't work either, but thanks.
If you post your workbook for me to modify I can provide a solution. It worked for me in a sample workbook.
When you say it doesn't work, what exactly happens?
Thank you. I am trying to calculate the 30 min range (H-L) on 5 min bars of data
PS I added a header row for clarification, so the formula would start at C2, not C1
Last edited by jimbob; 10-09-2011 at 05:43 PM.
There was an error in the formula. The correct formula, which now takes into account the header row, is
If you do not use a header row then the formula has to change.Please Login or Register to view this content.
Implementation attached.
Works for the first 277 lines, then it shows "0". The formula appears to be copying OK, just no calculation.
Last edited by jimbob; 10-10-2011 at 04:08 PM.
Heres the worksheet
The calculation is working as specified. Starting in row 278, the formula refers to data in rows 1658-1664. Those rows (and those beyond) don't have any data in them.
Thank you so much for your help. This is a really great forum.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks