Calculate values with a maximum ceiling, spilling whats left to the next

T

TenTwenty

New Member
Joined
Feb 20, 2018
Messages
14
I have the following table. Problem is I really am stuck with this one. Columns in red are the ones I'm testing against. The values entered in columns E,H, K and N will be tested against the values in columns F, H, K and N. The latter columns in a ceiling and if the calculated value in E,H, K and N exceed the ceiling then it will spill over to the next. That is working sort of but the problem is when the month are the same for two or more rows.

Below is the table values with the formulas that I use.


[TABLE="width: 1003"]
<tbody>[TR]
[TD]Excel 2016
[TABLE="class: grid, width: 20, align: right"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[TD]K[/TD]
[TD]L[/TD]
[TD]M[/TD]
[TD]N[/TD]
[TD]O[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Date[/TD]
[TD]Month[/TD]
[TD]Reading[/TD]
[TD]Test1[/TD]
[TD]Tarif1[/TD]
[TD]Cap1[/TD]
[TD]Test2[/TD]
[TD]Tarif2[/TD]
[TD]Cap2[/TD]
[TD]Test3[/TD]
[TD]Tarif3[/TD]
[TD]Cap3[/TD]
[TD]Test4[/TD]
[TD]Tarif4[/TD]
[TD]Cap4[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]1/7/18[/TD]
[TD]July[/TD]
[TD]550[/TD]
[TD]50[/TD]
[TD]50[/TD]
[TD]50[/TD]
[TD]250[/TD]
[TD]250[/TD]
[TD]250[/TD]
[TD][/TD]
[TD][/TD]
[TD]300[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]1/8/18[/TD]
[TD]August[/TD]
[TD]570[/TD]
[TD]50[/TD]
[TD]50[/TD]
[TD]50[/TD]
[TD]250[/TD]
[TD]270[/TD]
[TD]250[/TD]
[TD][/TD]
[TD][/TD]
[TD]300[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]15/8/18[/TD]
[TD]August[/TD]
[TD]280[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]50[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]250[/TD]
[TD][/TD]
[TD][/TD]
[TD]300[/TD]
[TD]250[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]20/8/18[/TD]
[TD]August[/TD]
[TD]320[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]50[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]250[/TD]
[TD][/TD]
[TD][/TD]
[TD]300[/TD]
[TD]320[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]25/8/18[/TD]
[TD]August[/TD]
[TD]180[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]50[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]250[/TD]
[TD][/TD]
[TD][/TD]
[TD]300[/TD]
[TD]180[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]2/9/18[/TD]
[TD]Sept[/TD]
[TD]1200[/TD]
[TD]50[/TD]
[TD]50[/TD]
[TD]50[/TD]
[TD]250[/TD]
[TD]900[/TD]
[TD]250[/TD]
[TD][/TD]
[TD][/TD]
[TD]300[/TD]
[TD]600[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]Formulas
[TABLE="class: grid, width: 40"]
<tbody>[TR]
[TD]B2[/TD]
[TD]=TEXT(A2,"mmmm")[/TD]
[/TR]
[TR]
[TD]F2[/TD]
[TD]=IF(C2>F2,IF(B2=B1,0,F2),C2)[/TD]
[/TR]
[TR]
[TD]H2[/TD]
[TD]=IF(C2>F2+I2,IF(B2=B1,0,IF(280-0-250>I2,IF(B2=B1,0,I2),C2-E2-I2)),IF(H2>0,C2-F2,C2))[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
 

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.
Sort by date Sort by votes
[TABLE="width: 997"]
<colgroup><col span="4"><col><col><col><col span="7"></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD]t1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]date[/TD]
[TD]units used[/TD]
[TD]tarriiff[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]50[/TD]
[TD]t1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01/08/2018[/TD]
[TD="align: right"]570[/TD]
[TD]t5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]300[/TD]
[TD]t2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]15/08/2018[/TD]
[TD="align: right"]280[/TD]
[TD]t1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]350[/TD]
[TD]t3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]20/08/2018[/TD]
[TD="align: right"]320[/TD]
[TD]t2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]400[/TD]
[TD]t4[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]25/08/2018[/TD]
[TD="align: right"]180[/TD]
[TD]t1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]450[/TD]
[TD]t5[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]02/09/2018[/TD]
[TD="align: right"]49[/TD]
[TD]t1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]9999[/TD]
[TD]t5[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 3"]is this approach close to what you want ?[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
TenTwenty said:
Below is the table values with the formulas that I use.
Click to expand...
Could you show us the table again with the values you want, instead of the values your incorrect formulas are returning?
Also try to explain again, differently, how you manually work out the required results.

Also, there seems to be a problem with the formulas you reported, or at least how you reported them
- You have quoted a formula for cell F2, but that formula refers to cell F2
- You have quoted a formula for cell H2, but that formula refers to cell H2

Can you clarify where/what the formulas actually are?
 
Last edited:
Upvote 0
Peter_SSs said:
Could you show us the table again with the values you want, instead of the values your incorrect formulas are returning?
Also try to explain again, differently, how you manually work out the required results.

Also, there seems to be a problem with the formulas you reported, or at least how you reported them
- You have quoted a formula for cell F2, but that formula refers to cell F2
- You have quoted a formula for cell H2, but that formula refers to cell H2

Can you clarify where/what the formulas actually are?
Click to expand...

Hi,

Columns in red is just for me to quickly check if it my results is correct, they will be deleted afterwards.
For the other, I see a circular reference guess I paste the code while working on it.:mad: I got it going up to column E but that is that.

In theory, if I enter a reading in column C, then the formulas in columns E, H K and M must calculate the values. Ex. If I enter 500, then column E can not be more than the value in column F (50) (that is the cap or ceiling). The value that is more will now be passed to column H, thus 450, The ceiling for column H is set by column I which is now 250. H will now only have a value of 250 and the remainder will spill over to column K

The crux is now that if there is another entry for the same month on the next line then the process should continue where the previous entry on the previous line stopped. I hope this help.
 
Upvote 0
TenTwenty said:
The crux is now that if there is another entry for the same month on the next line then the process should continue where the previous entry on the previous line stopped. I hope this help.
Click to expand...
Not really, which is why I would like to see exactly what you have and what you expect, particularly where there are multiple rows for the same month.
 
Upvote 0
Peter_SSs said:
Could you show us the table again with the values you want, instead of the values your incorrect formulas are returning?
Also try to explain again, differently, how you manually work out the required results.

Also, there seems to be a problem with the formulas you reported, or at least how you reported them
- You have quoted a formula for cell F2, but that formula refers to cell F2
- You have quoted a formula for cell H2, but that formula refers to cell H2

Can you clarify where/what the formulas actually are?
Click to expand...

Here is a more clean table.

[TABLE="class: grid, width: 100"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[TD]F
[/TD]
[TD]G
[/TD]
[TD]H
[/TD]
[TD]I
[/TD]
[TD]J
[/TD]
[TD]K
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]Date
[/TD]
[TD]Month
[/TD]
[TD]Reading
[/TD]
[TD]Tariff1
[/TD]
[TD]Cap1
[/TD]
[TD]Tariff2
[/TD]
[TD]Cap2
[/TD]
[TD]Tariff3
[/TD]
[TD]Cap3
[/TD]
[TD]Tariff4
[/TD]
[TD]Cap4
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]1/7/18
[/TD]
[TD]Jul
[/TD]
[TD]550
[/TD]
[TD]50
[/TD]
[TD]50
[/TD]
[TD]250
[/TD]
[TD]250
[/TD]
[TD]250
[/TD]
[TD]300
[/TD]
[TD]0
[/TD]
[TD]9999
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]1/8/18
[/TD]
[TD]Aug
[/TD]
[TD]570
[/TD]
[TD]50
[/TD]
[TD]50
[/TD]
[TD]250
[/TD]
[TD]250
[/TD]
[TD]270
[/TD]
[TD]300
[/TD]
[TD]0
[/TD]
[TD]9999
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]15/8/18
[/TD]
[TD]Aug
[/TD]
[TD]280
[/TD]
[TD]0
[/TD]
[TD]50
[/TD]
[TD]0
[/TD]
[TD]250
[/TD]
[TD]30
[/TD]
[TD]300
[/TD]
[TD]250
[/TD]
[TD]9999
[/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD]20/8/18
[/TD]
[TD]Aug
[/TD]
[TD]320
[/TD]
[TD]0
[/TD]
[TD]50
[/TD]
[TD]0
[/TD]
[TD]250
[/TD]
[TD]0
[/TD]
[TD]300
[/TD]
[TD]320
[/TD]
[TD]9999
[/TD]
[/TR]
[TR]
[TD]6
[/TD]
[TD]25/8/18
[/TD]
[TD]Aug
[/TD]
[TD]180
[/TD]
[TD]0
[/TD]
[TD]50
[/TD]
[TD]0
[/TD]
[TD]250
[/TD]
[TD]0
[/TD]
[TD]300
[/TD]
[TD]180
[/TD]
[TD]9999
[/TD]
[/TR]
[TR]
[TD]7
[/TD]
[TD]1/9/18
[/TD]
[TD]Sep
[/TD]
[TD]1200
[/TD]
[TD]50
[/TD]
[TD]50
[/TD]
[TD]250
[/TD]
[TD]250
[/TD]
[TD]300
[/TD]
[TD]300
[/TD]
[TD]600
[/TD]
[TD]9999
[/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
oldbrewer said:
[TABLE="width: 997"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD]t1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]date[/TD]
[TD]units used[/TD]
[TD]tarriiff[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]50[/TD]
[TD]t1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01/08/2018[/TD]
[TD="align: right"]570[/TD]
[TD]t5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]300[/TD]
[TD]t2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]15/08/2018[/TD]
[TD="align: right"]280[/TD]
[TD]t1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]350[/TD]
[TD]t3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]20/08/2018[/TD]
[TD="align: right"]320[/TD]
[TD]t2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]400[/TD]
[TD]t4[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]25/08/2018[/TD]
[TD="align: right"]180[/TD]
[TD]t1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]450[/TD]
[TD]t5[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]02/09/2018[/TD]
[TD="align: right"]49[/TD]
[TD]t1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]9999[/TD]
[TD]t5[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 3"]is this approach close to what you want ?[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Click to expand...

.... not realy .....
 
Upvote 0
@oldbrewer

Yes, I would like it to calculate electricity and costs thereoff that I buy from my utility. I would like to do pivots on usage , costs, high and lows, seasons, etc.
 
Upvote 0
You must log in or register to reply here.

Similar threads

A
  • Solved
Data Selection Based on Values
Replies
6
Views
166
Anonnymouse
A
A
  • Question Question
Abstract the Quantity Consumption
Replies
1
Views
93
Rijnsent
Rijnsent
A
  • Question Question
Data Selection Based on Closest Value [20% Tolerance]
Replies
1
Views
204
StephenCrump
S
S
  • Question Question
Pro Rata a Sumproduct Calculation
Replies
1
Views
316
myall_blues
myall_blues
J
  • Solved
Using LEFT Function On a Range Instead of A Single Cell Value
Replies
4
Views
74
Fluff
Fluff

Forum statistics

Threads
1,223,893
Messages
6,175,242
Members
452,623
Latest member
russelllowellpercy

Share this page

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
Back
Top