Absolute formulas

I need to sum the values from the top cell and subtract the bottom cell
E2-E3 and then
E2-E4
putting the result in R3 and R4
I can uses the absolute cell for the first column, but now I want
use that same formula in the next column, F and the answers in S

Thanks
IS-126-finish.xls
thebigtableAsked:
Who is Participating?
 
Saqib Husain, SyedEngineerCommented:
Try this formula in R3

=E3-INDEX($A:$P,INT((ROW()-2)/7)*7+2,COLUMN(E$1))

This formula assumes that there are exactly 7 rows for each set.
0
 
AnuroopsunddCommented:
Copy the E cell where you have the formula.

Right Click on the F column where you want to paste the formula.. select Paste special.. and select formula...
0
 
Shanan212Commented:
=E4-E$2

Place the formula as such (remove the $ sign infront of the "$E$2"

Then you could drag it down/accross for column F
0
 
thebigtableAuthor Commented:
I need to carry this down the rows for several groups skiping a row evry 6 rows.  This then changes the formula
From E4- to E9-
Not the formula in R3 thru AC3.  For  I am always subtracting the value of the cells under the highlighted cells to give me the difference from the starting point.
So I need to repeat R3 : AC3 down to R8 : AC8

I was hoping this was somethig that could be done programatically.  If not , I can go with the manula route.
sampleIS-126-finish.xls
0
 
thebigtableAuthor Commented:
It worked beautifully!
Many thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.