Forum Discussion
Solved
Looking for a column formula that applies to the last 10 entries in a row
Hi there, I am looking for a formula (to apply in the cells in the red column below) that will automatically give me 1,2 * the MAX of the last 5 data entries directly to the left of a particular...
Let's say the first formula is currently in G2. Enter the following formula there:
=1.2*MAX(OFFSET(G2,0,-5):OFFSET(G2,0,-1))
Fill down. The formulas will always refer to the 5 columns to the left of the cell with the formula.
Let's say the first formula is currently in G2. Enter the following formula there:
=1.2*MAX(OFFSET(G2,0,-5):OFFSET(G2,0,-1))
Fill down. The formulas will always refer to the 5 columns to the left of the cell with the formula.
Thanks so much, that works perfectly!