# Data update based on periodical base date data change

#### Muthukrishnan V

##### Board Regular
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:

### Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

Replies
7
Views
294
Replies
1
Views
174
Replies
7
Views
122
Replies
20
Views
300
Replies
3
Views
179

### Forum statistics

1,126,928
Messages
5,621,642
Members
415,849
Latest member
PhoenixRising2015

### 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.

### Which adblocker are you using?

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

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