to Eliminate row needed for gapup and reoccurance function and data

zoharb

New Member
Joined
Nov 24, 2011
Messages
22
Respected ,
(1)Way
in calculation of gapup and reoccurance,

Is there anyway so that formulas done in a10,b10, A13,B13 & A16,b16) can be accomodated in A11, a14 & A17
formula in Row 10,13,16,.......... has to be maintained , as it is referenced by formulas in A11, a14 & A17 which complicates the structure.(has to insert extra row)

(2) way
There is the data that is obtained from the level mapping software that is in Row 9,12,15,18
the calculations of gapup & reoccurance(of gapup) is calcuated in ROW a10,b10, a13,b13, a16,b13
The other calculations based on it are in ROW a11,a14,a17
I was able to display the calculated data of Row 10,13,16 in ROW 11,14,17
but further down calculations can not be done as the data in ROW 10,13.16 are used as input in calculations of Row 11,13,16,17, and there it is mixed with other data , calculation in 11,14,17 is not done.
I am looking the way so that the though the data of ROw 9 gets accommodated in Row 10, but calculation of 11,14,17, can be obtained,
Same repeats further.
Please
(3)way
To put all things again

data in Row 9,12,15 & 18 is the data
-opening(col A) & closing(col B) RAW reading of today

data in Row 10,13,16 is the data that is obtained from formulas
-COL A-gapup-down in % of todays opening compared to previous days close(for calculation Base is previous days closing)
-COL B-reoccurance of thing gapup-down trend

data in ROW 11,14,17,20
difference of previous days; gapup-down-that is in a10,a13,a16, its 2-day and 3-average


(what I need
--at present to correctly use the gapup-down data(Row 10,13,16) , it has to be seperately plaaced,
I want to merge it in calculated data in ROW 11,14,17,20

(purpose-one row will be saved , where I can put other+weekly data)

xls file with data is in dropbox
https://www.dropbox.com/s/i0yd4yetzzixxr8/forum%402feb.xls?dl=0

PLEASE PLEASE help me
Zohar Batterywala
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

Watch MrExcel Video

Forum statistics

Threads
1,129,467
Messages
5,636,456
Members
416,919
Latest member
twc2c

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top