Solved

Absolute formulas

Posted on 2012-04-10
5
221 Views
Last Modified: 2012-04-11
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
0
Comment
Question by:thebigtable
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 17

Expert Comment

by:Anuroopsundd
ID: 37829980
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
 
LVL 13

Expert Comment

by:Shanan212
ID: 37829982
=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
 

Author Comment

by:thebigtable
ID: 37832026
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
 
LVL 43

Accepted Solution

by:
Saqib Husain, Syed earned 500 total points
ID: 37832193
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
 

Author Closing Comment

by:thebigtable
ID: 37832402
It worked beautifully!
Many thanks
0

Featured Post

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

737 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question