Data update based on periodical base date data change

Muthukrishnan V

Board Regular
Joined
May 29, 2008
Messages
183
Office Version
  1. 365
Platform
  1. Windows
Solar query to BB.xlsx
ABCDEFGHIJK
1No, of Units consumed on daily basis based on the Units reading in Col F
2
3DateUnitsNo.of Unit
4BaseDateUnits
514-08-20201641.00161
615-08-20201645.0016521-07-20201480
716-08-20201650.0017020-09-20201738
804-09-20201692.00212
913-09-20201722.00242
1020-09-20201738.00258
1121-09-20201740.00260C11 should be 2, i,e. (B11-F7; and not B11-F6) because base date & units changed
1222-09-2020 
13 
14 
Sheet1
Cell Formulas
RangeFormula
A6:A7,A12A6=$A5+1
C5:C12C5=IF(B5<=0,"",B5-F$6)
C13:C14C13=IF(B13<=0,"",B13-F14)


Data update based on periodical base date figure change

I attach SolarBB excel worksheet in XL2BB.

I post units on day to day basis in Col A and B, to find the number of units
consumed from base date figures in Col E and F.
E and F gets periodically updated once in two months.
Col C calculates the number of units consumed from Col F.

My requirement: When Col F gets updated, Column C calcuation should take
revised date in Col E.

Kindly advise formula in Column C.

Thanking you,
 
Last edited by a moderator:

Some videos you may like

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

Watch MrExcel Video

Forum statistics

Threads
1,123,477
Messages
5,601,893
Members
414,479
Latest member
Beau the dog

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