Offsetting dates / usage in vlookup or index/match function

P

PureBluff

Board Regular
Joined
Apr 4, 2014
Messages
174
Office Version
  1. 2016
Platform
  1. Windows
  2. Mobile
Good morning all,

Here in the UK, we have an energy provider (Octopus) who offer fluctuating rates depending on the tariff you're on.
The key ones here are:
Agile: The rate changes every 30 minutes
Tracker: The rate changes daily

Naturally, in the UK, we also have British Summer Time and Greenwich Mean Time - however Octopus on the whole use UTC. This is where my issue arises.

The consumption data from their API looks like this, note on the 26th March 23 going into the 27th, the interval date adds in the +01:00 hour:

consumptioninterval_startinterval_end
0.2262023-03-24T23:00:00Z2023-03-24T23:30:00Z
0.2092023-03-24T23:30:00Z2023-03-25T00:00:00Z
0.2112023-03-25T00:00:00Z2023-03-25T00:30:00Z
0.1992023-03-25T00:30:00Z2023-03-25T01:00:00Z
0.2182023-03-25T01:00:00Z2023-03-25T01:30:00Z
0.1942023-03-25T01:30:00Z2023-03-25T02:00:00Z
0.2252023-03-25T02:00:00Z2023-03-25T02:30:00Z
0.1942023-03-25T02:30:00Z2023-03-25T03:00:00Z
0.2192023-03-25T03:00:00Z2023-03-25T03:30:00Z
0.2092023-03-25T03:30:00Z2023-03-25T04:00:00Z
0.2112023-03-25T04:00:00Z2023-03-25T04:30:00Z
0.2252023-03-25T04:30:00Z2023-03-25T05:00:00Z
0.2032023-03-25T05:00:00Z2023-03-25T05:30:00Z
0.2252023-03-25T05:30:00Z2023-03-25T06:00:00Z
0.1932023-03-25T06:00:00Z2023-03-25T06:30:00Z
0.2062023-03-25T06:30:00Z2023-03-25T07:00:00Z
0.3532023-03-25T07:00:00Z2023-03-25T07:30:00Z
0.2122023-03-25T07:30:00Z2023-03-25T08:00:00Z
0.6572023-03-25T08:00:00Z2023-03-25T08:30:00Z
0.32023-03-25T08:30:00Z2023-03-25T09:00:00Z
0.2432023-03-25T09:00:00Z2023-03-25T09:30:00Z
0.282023-03-25T09:30:00Z2023-03-25T10:00:00Z
0.3542023-03-25T10:00:00Z2023-03-25T10:30:00Z
0.1222023-03-25T10:30:00Z2023-03-25T11:00:00Z
0.0472023-03-25T11:00:00Z2023-03-25T11:30:00Z
0.4572023-03-25T11:30:00Z2023-03-25T12:00:00Z
0.3622023-03-25T12:00:00Z2023-03-25T12:30:00Z
0.3842023-03-25T12:30:00Z2023-03-25T13:00:00Z
0.4612023-03-25T13:00:00Z2023-03-25T13:30:00Z
0.552023-03-25T13:30:00Z2023-03-25T14:00:00Z
0.3972023-03-25T14:00:00Z2023-03-25T14:30:00Z
1.0312023-03-25T14:30:00Z2023-03-25T15:00:00Z
0.5762023-03-25T15:00:00Z2023-03-25T15:30:00Z
0.3982023-03-25T15:30:00Z2023-03-25T16:00:00Z
0.0412023-03-25T16:00:00Z2023-03-25T16:30:00Z
0.0732023-03-25T16:30:00Z2023-03-25T17:00:00Z
0.4922023-03-25T17:00:00Z2023-03-25T17:30:00Z
0.4082023-03-25T17:30:00Z2023-03-25T18:00:00Z
0.8732023-03-25T18:00:00Z2023-03-25T18:30:00Z
0.8242023-03-25T18:30:00Z2023-03-25T19:00:00Z
0.6092023-03-25T19:00:00Z2023-03-25T19:30:00Z
0.4332023-03-25T19:30:00Z2023-03-25T20:00:00Z
0.452023-03-25T20:00:00Z2023-03-25T20:30:00Z
0.4352023-03-25T20:30:00Z2023-03-25T21:00:00Z
0.5052023-03-25T21:00:00Z2023-03-25T21:30:00Z
0.3852023-03-25T21:30:00Z2023-03-25T22:00:00Z
0.3722023-03-25T22:00:00Z2023-03-25T22:30:00Z
0.3542023-03-25T22:30:00Z2023-03-25T23:00:00Z
0.3822023-03-25T23:00:00Z2023-03-25T23:30:00Z
0.3162023-03-25T23:30:00Z2023-03-26T00:00:00Z
0.3452023-03-26T00:00:00Z2023-03-26T00:30:00Z
0.3162023-03-26T00:30:00Z2023-03-26T02:00:00+01:00
0.3432023-03-26T02:00:00+01:002023-03-26T02:30:00+01:00
0.3182023-03-26T02:30:00+01:002023-03-26T03:00:00+01:00
0.342023-03-26T03:00:00+01:002023-03-26T03:30:00+01:00
0.3172023-03-26T03:30:00+01:002023-03-26T04:00:00+01:00
0.3422023-03-26T04:00:00+01:002023-03-26T04:30:00+01:00
0.3152023-03-26T04:30:00+01:002023-03-26T05:00:00+01:00
0.3462023-03-26T05:00:00+01:002023-03-26T05:30:00+01:00
0.3152023-03-26T05:30:00+01:002023-03-26T06:00:00+01:00
0.3452023-03-26T06:00:00+01:002023-03-26T06:30:00+01:00
0.3162023-03-26T06:30:00+01:002023-03-26T07:00:00+01:00
0.3412023-03-26T07:00:00+01:002023-03-26T07:30:00+01:00
0.3092023-03-26T07:30:00+01:002023-03-26T08:00:00+01:00
0.3482023-03-26T08:00:00+01:002023-03-26T08:30:00+01:00
0.342023-03-26T08:30:00+01:002023-03-26T09:00:00+01:00
0.4272023-03-26T09:00:00+01:002023-03-26T09:30:00+01:00
0.4012023-03-26T09:30:00+01:002023-03-26T10:00:00+01:00
0.4322023-03-26T10:00:00+01:002023-03-26T10:30:00+01:00
0.3612023-03-26T10:30:00+01:002023-03-26T11:00:00+01:00
0.3642023-03-26T11:00:00+01:002023-03-26T11:30:00+01:00
0.3642023-03-26T11:30:00+01:002023-03-26T12:00:00+01:00
0.6242023-03-26T12:00:00+01:002023-03-26T12:30:00+01:00
0.1942023-03-26T12:30:00+01:002023-03-26T13:00:00+01:00
0.4182023-03-26T13:00:00+01:002023-03-26T13:30:00+01:00
0.5992023-03-26T13:30:00+01:002023-03-26T14:00:00+01:00
1.1432023-03-26T14:00:00+01:002023-03-26T14:30:00+01:00
0.7382023-03-26T14:30:00+01:002023-03-26T15:00:00+01:00
0.5672023-03-26T15:00:00+01:002023-03-26T15:30:00+01:00
0.3992023-03-26T15:30:00+01:002023-03-26T16:00:00+01:00
0.3612023-03-26T16:00:00+01:002023-03-26T16:30:00+01:00
0.4512023-03-26T16:30:00+01:002023-03-26T17:00:00+01:00
0.3592023-03-26T17:00:00+01:002023-03-26T17:30:00+01:00
0.3842023-03-26T17:30:00+01:002023-03-26T18:00:00+01:00
0.4152023-03-26T18:00:00+01:002023-03-26T18:30:00+01:00
0.9322023-03-26T18:30:00+01:002023-03-26T19:00:00+01:00
0.4382023-03-26T19:00:00+01:002023-03-26T19:30:00+01:00
0.4352023-03-26T19:30:00+01:002023-03-26T20:00:00+01:00
0.4052023-03-26T20:00:00+01:002023-03-26T20:30:00+01:00
0.4292023-03-26T20:30:00+01:002023-03-26T21:00:00+01:00
0.4042023-03-26T21:00:00+01:002023-03-26T21:30:00+01:00
0.4152023-03-26T21:30:00+01:002023-03-26T22:00:00+01:00
0.3572023-03-26T22:00:00+01:002023-03-26T22:30:00+01:00
0.3822023-03-26T22:30:00+01:002023-03-26T23:00:00+01:00
0.3782023-03-26T23:00:00+01:002023-03-26T23:30:00+01:00
0.3662023-03-26T23:30:00+01:002023-03-27T00:00:00+01:00
0.3312023-03-27T00:00:00+01:002023-03-27T00:30:00+01:00
0.3332023-03-27T00:30:00+01:002023-03-27T01:00:00+01:00
0.3392023-03-27T01:00:00+01:002023-03-27T01:30:00+01:00
0.3182023-03-27T01:30:00+01:002023-03-27T02:00:00+01:00
0.3492023-03-27T02:00:00+01:002023-03-27T02:30:00+01:00
0.322023-03-27T02:30:00+01:002023-03-27T03:00:00+01:00
0.3492023-03-27T03:00:00+01:002023-03-27T03:30:00+01:00
0.3242023-03-27T03:30:00+01:002023-03-27T04:00:00+01:00
0.3362023-03-27T04:00:00+01:002023-03-27T04:30:00+01:00
0.3362023-03-27T04:30:00+01:002023-03-27T05:00:00+01:00
0.322023-03-27T05:00:00+01:002023-03-27T05:30:00+01:00
0.4962023-03-27T05:30:00+01:002023-03-27T06:00:00+01:00
0.372023-03-27T06:00:00+01:002023-03-27T06:30:00+01:00
0.3832023-03-27T06:30:00+01:002023-03-27T07:00:00+01:00
0.3142023-03-27T07:00:00+01:002023-03-27T07:30:00+01:00


The pricing file for Agile follows this format:

Interval_FromTimePrice_IndexRegionCost
2023/03/25 11:0011:00:00BEast_Midlands18.186
2023/03/25 11:3011:30:00BEast_Midlands19.845
2023/03/25 12:0012:00:00BEast_Midlands24.549
2023/03/25 12:3012:30:00BEast_Midlands19.866
2023/03/25 13:0013:00:00BEast_Midlands21.63
2023/03/25 13:3013:30:00BEast_Midlands21.63
2023/03/25 14:0014:00:00BEast_Midlands22.89
2023/03/25 14:3014:30:00BEast_Midlands21.441
2023/03/25 15:0015:00:00BEast_Midlands18.354
2023/03/25 15:3015:30:00BEast_Midlands20.391
2023/03/25 16:0016:00:00BEast_Midlands33.0182
2023/03/25 16:3016:30:00BEast_Midlands33.0182
2023/03/25 17:0017:00:00BEast_Midlands33.0182
2023/03/25 17:3017:30:00BEast_Midlands33.0182
2023/03/25 18:0018:00:00BEast_Midlands33.0182
2023/03/25 18:3018:30:00BEast_Midlands33.0182
2023/03/25 19:0019:00:00BEast_Midlands32.55
2023/03/25 19:3019:30:00BEast_Midlands28.644
2023/03/25 20:0020:00:00BEast_Midlands29.904
2023/03/25 20:3020:30:00BEast_Midlands22.554
2023/03/25 21:0021:00:00BEast_Midlands24.003
2023/03/25 21:3021:30:00BEast_Midlands21.189
2023/03/25 22:0022:00:00BEast_Midlands23.667
2023/03/25 22:3022:30:00BEast_Midlands20.013
2023/03/25 23:0023:00:00BEast_Midlands24.192
2023/03/25 23:3023:30:00BEast_Midlands25.788
2023/03/26 00:0000:00:00BEast_Midlands25.515
2023/03/26 00:3000:30:00BEast_Midlands27.3
2023/03/26 02:0002:00:00BEast_Midlands24.57
2023/03/26 02:3002:30:00BEast_Midlands23.73
2023/03/26 03:0003:00:00BEast_Midlands24.15
2023/03/26 03:3003:30:00BEast_Midlands22.05
2023/03/26 04:0004:00:00BEast_Midlands20.391
2023/03/26 04:3004:30:00BEast_Midlands16.359
2023/03/26 05:0005:00:00BEast_Midlands15.897
2023/03/26 05:3005:30:00BEast_Midlands14.28
2023/03/26 06:0006:00:00BEast_Midlands14.637
2023/03/26 06:3006:30:00BEast_Midlands16.569
2023/03/26 07:0007:00:00BEast_Midlands12.81
2023/03/26 07:3007:30:00BEast_Midlands18.186
2023/03/26 08:0008:00:00BEast_Midlands14.7
2023/03/26 08:3008:30:00BEast_Midlands20.496
2023/03/26 09:0009:00:00BEast_Midlands22.239
2023/03/26 09:3009:30:00BEast_Midlands22.281
2023/03/26 10:0010:00:00BEast_Midlands23.52
2023/03/26 10:3010:30:00BEast_Midlands27.699
2023/03/26 11:0011:00:00BEast_Midlands24.36
2023/03/26 11:3011:30:00BEast_Midlands24.444
2023/03/26 12:0012:00:00BEast_Midlands25.2
2023/03/26 12:3012:30:00BEast_Midlands25.2
2023/03/26 13:0013:00:00BEast_Midlands22.848
2023/03/26 13:3013:30:00BEast_Midlands22.47
2023/03/26 14:0014:00:00BEast_Midlands19.95
2023/03/26 14:3014:30:00BEast_Midlands19.95
2023/03/26 15:0015:00:00BEast_Midlands19.278
2023/03/26 15:3015:30:00BEast_Midlands20.37
2023/03/26 16:0016:00:00BEast_Midlands32.55
2023/03/26 16:3016:30:00BEast_Midlands33.0182
2023/03/26 17:0017:00:00BEast_Midlands33.0182
2023/03/26 17:3017:30:00BEast_Midlands33.0182
2023/03/26 18:0018:00:00BEast_Midlands33.0182
2023/03/26 18:3018:30:00BEast_Midlands33.0182
2023/03/26 19:0019:00:00BEast_Midlands29.652
2023/03/26 19:3019:30:00BEast_Midlands29.568
2023/03/26 20:0020:00:00BEast_Midlands32.928
2023/03/26 20:3020:30:00BEast_Midlands27.195
2023/03/26 21:0021:00:00BEast_Midlands29.232
2023/03/26 21:3021:30:00BEast_Midlands17.472
2023/03/26 22:0022:00:00BEast_Midlands17.43
2023/03/26 22:3022:30:00BEast_Midlands16.38
2023/03/26 23:0023:00:00BEast_Midlands24.255
2023/03/26 23:3023:30:00BEast_Midlands23.184
2023/03/27 00:0000:00:00BEast_Midlands21
2023/03/27 00:3000:30:00BEast_Midlands19.929
2023/03/27 01:0001:00:00BEast_Midlands21.819
2023/03/27 01:3001:30:00BEast_Midlands21.777
2023/03/27 02:0002:00:00BEast_Midlands22.47
2023/03/27 02:3002:30:00BEast_Midlands21
2023/03/27 03:0003:00:00BEast_Midlands20.979
2023/03/27 03:3003:30:00BEast_Midlands19.95
2023/03/27 04:0004:00:00BEast_Midlands21
2023/03/27 04:3004:30:00BEast_Midlands21
2023/03/27 05:0005:00:00BEast_Midlands26.565
2023/03/27 05:3005:30:00BEast_Midlands24.192
2023/03/27 06:0006:00:00BEast_Midlands26.46
2023/03/27 06:3006:30:00BEast_Midlands24.255
2023/03/27 07:0007:00:00BEast_Midlands24.255
2023/03/27 07:3007:30:00BEast_Midlands32.886
2023/03/27 08:0008:00:00BEast_Midlands29.232
2023/03/27 08:3008:30:00BEast_Midlands29.232
2023/03/27 09:0009:00:00BEast_Midlands28.896
2023/03/27 09:3009:30:00BEast_Midlands27.321
2023/03/27 10:0010:00:00BEast_Midlands25.2
2023/03/27 10:3010:30:00BEast_Midlands22.239
2023/03/27 11:0011:00:00BEast_Midlands22.344
2023/03/27 11:3011:30:00BEast_Midlands24.423
2023/03/27 12:0012:00:00BEast_Midlands24.15
2023/03/27 12:3012:30:00BEast_Midlands23.436
2023/03/27 13:0013:00:00BEast_Midlands22.47
2023/03/27 13:3013:30:00BEast_Midlands21.441
2023/03/27 14:0014:00:00BEast_Midlands22.008
2023/03/27 14:3014:30:00BEast_Midlands20.118
2023/03/27 15:0015:00:00BEast_Midlands19.11
2023/03/27 15:3015:30:00BEast_Midlands19.11
2023/03/27 16:0016:00:00BEast_Midlands33.0182
2023/03/27 16:3016:30:00BEast_Midlands33.0182
2023/03/27 17:0017:00:00BEast_Midlands33.0182
2023/03/27 17:3017:30:00BEast_Midlands33.0182
2023/03/27 18:0018:00:00BEast_Midlands33.0182
2023/03/27 18:3018:30:00BEast_Midlands33.0182
2023/03/27 19:0019:00:00BEast_Midlands33.0182
2023/03/27 19:3019:30:00BEast_Midlands33.0182
2023/03/27 20:0020:00:00BEast_Midlands33.0182
2023/03/27 20:3020:30:00BEast_Midlands29.904
2023/03/27 21:0021:00:00BEast_Midlands29.568
2023/03/27 21:3021:30:00BEast_Midlands21.042
2023/03/27 22:0022:00:00BEast_Midlands24.255
2023/03/27 22:3022:30:00BEast_Midlands20.37
2023/03/27 23:0023:00:00BEast_Midlands25.2
2023/03/27 23:3023:30:00BEast_Midlands23.94
2023/03/28 00:0000:00:00BEast_Midlands27.552
2023/03/28 00:3000:30:00BEast_Midlands25.557
2023/03/28 01:0001:00:00BEast_Midlands22.05
2023/03/28 01:3001:30:00BEast_Midlands25.83
2023/03/28 02:0002:00:00BEast_Midlands23.31
2023/03/28 02:3002:30:00BEast_Midlands18.9
2023/03/28 03:0003:00:00BEast_Midlands20.7795
2023/03/28 03:3003:30:00BEast_Midlands17.43
2023/03/28 04:0004:00:00BEast_Midlands20.832
2023/03/28 04:3004:30:00BEast_Midlands19.299
2023/03/28 05:0005:00:00BEast_Midlands23.268
2023/03/28 05:3005:30:00BEast_Midlands23.1
2023/03/28 06:0006:00:00BEast_Midlands27.3
2023/03/28 06:3006:30:00BEast_Midlands30.576
2023/03/28 07:0007:00:00BEast_Midlands27.09
2023/03/28 07:3007:30:00BEast_Midlands33.0182
2023/03/28 08:0008:00:00BEast_Midlands27.3


and the tracker following this format:

Interval_FromTimePrice_IndexRegionCost
01/03/2023 00:0000:00:00BEast_Midlands24.13
02/03/2023 00:0000:00:00BEast_Midlands24.61
03/03/2023 00:0000:00:00BEast_Midlands25.03
04/03/2023 00:0000:00:00BEast_Midlands23.58
05/03/2023 00:0000:00:00BEast_Midlands23.99
06/03/2023 00:0000:00:00BEast_Midlands24.56
07/03/2023 00:0000:00:00BEast_Midlands24.43
08/03/2023 00:0000:00:00BEast_Midlands23.95
09/03/2023 00:0000:00:00BEast_Midlands23.1
10/03/2023 00:0000:00:00BEast_Midlands21.98
11/03/2023 00:0000:00:00BEast_Midlands23.5
12/03/2023 00:0000:00:00BEast_Midlands21.59
13/03/2023 00:0000:00:00BEast_Midlands19.61
14/03/2023 00:0000:00:00BEast_Midlands21.9
15/03/2023 00:0000:00:00BEast_Midlands24.56
16/03/2023 00:0000:00:00BEast_Midlands22.1
17/03/2023 00:0000:00:00BEast_Midlands21.71
18/03/2023 00:0000:00:00BEast_Midlands21.82
19/03/2023 00:0000:00:00BEast_Midlands21.69
20/03/2023 00:0000:00:00BEast_Midlands21.11
21/03/2023 00:0000:00:00BEast_Midlands20.09
22/03/2023 00:0000:00:00BEast_Midlands17.34
23/03/2023 00:0000:00:00BEast_Midlands18.39
24/03/2023 00:0000:00:00BEast_Midlands18.51
25/03/2023 00:0000:00:00BEast_Midlands18.15
26/03/2023 00:0000:00:00BEast_Midlands20.71
27/03/2023 01:0000:00:00BEast_Midlands21.43
28/03/2023 01:0000:00:00BEast_Midlands21.51
29/03/2023 01:0000:00:00BEast_Midlands20.82
30/03/2023 01:0000:00:00BEast_Midlands20.56
31/03/2023 01:0000:00:00BEast_Midlands21.15


For reference, the data are all collated from an API feed. The region and sheetname are currently taken from an indirect on Sheet "Config" and in cells C2 and C3 respectively

Octopus Consumption Comparison.xlsx
ABCDEFGHIJKLM
1AgileCodeRegion
2PricingBAEastern_England
3FilenameEast_MidlandsBEast_Midlands
4CLondon
5DMerseyside_and_Northern_Wales
6EWest_Midlands
7FNorth_Eastern_England
8GNorth_Western_England
9HSouthern_England
10JSouth_Eastern_England
11KSouthern_Wales
12LSouth_Western_England
13MYorkshire
14NSouthern_Scotland
15PNorthern_Scotland
16
Config
Cell Formulas
RangeFormula
C3C3=INDEX(M2:M15,MATCH(C2,L2:L15,0))


I wish to apply the correct pricing within the consumption sheet, for example

Agile:
Code: 
=VLOOKUP(VALUE(LEFT(B2, 10) & " " &    IF(RIGHT(B2,1)="Z",VALUE(MID($B2,12,2)),VALUE(MID(B4,12,2)))      &":" &     MID(B2, 15, 5)), INDIRECT("csv_agile_" & Config!$C$2 & "_" & Config!$C$3 & "!A:E"), 5, FALSE)

However, on the last 2 rows, this obviously has nothing to index against, but otherwise it works well.

Any idea's on how I can alter this to incorporate the interval_from change without using a row offset of 2? as that obviously fails on the last two 30 minute segments

And for tracker pricing, I don't know how to capture the change in the higlighted sections,

1691574012569.png


I have tried offsets against the interval date, but they break, because I was using
Code: 
=if(right(b1)="Z" ............
- which works for everything but the changeover from the 26th to the 27th.
Example of the formula I was trying to get to work but it has defeated me

Code: 
=VLOOKUP(VALUE(LEFT(B2, 10) & " " &    IF(RIGHT(B2,1)="Z","00:00:00","01:00:00")), INDIRECT("csv_tracker_" & Config!$C$2 & "_" & Config!$C$3 & "!A:%"), 5, FALSE)

This works, until the changeover as depicted below:
1691575598726.png
[/code]
 

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.
Sort by date Sort by votes
You show a lot of data, and ramble on about vague concepts, but your "question" is not clear at all. For example, you say :
I wish to apply the correct pricing within the consumption sheet, for example

Agile:
Code:
=VLOOKUP(VALUE(LEFT(B2, 10) & " " & IF(RIGHT(B2,1)="Z",VALUE(MID($B2,12,2)),VALUE(MID(B4,12,2))) &":" & MID(B2, 15, 5)), INDIRECT("csv_agile_" & Config!$C$2 & "_" & Config!$C$3 & "!A:E"), 5, FALSE)
Click to expand...

... so explain in detail what the logic is of that formula. Say why you are pointing 2 cells down.
 
Upvote 0
You must log in or register to reply here.

Similar threads

K
  • Question Question
Excel Pivot table Time Values is not populating same as Source Sheet
Replies
1
Views
607
awoohaw
awoohaw
S
  • Solved
Formula to split date and time and work out energy usage trend
Replies
6
Views
470
Sundance_Kid
S
sharky12345
  • Solved
Issue trying to identify earliest date & time
2
Replies
15
Views
551
sharky12345
sharky12345
L
  • Question Question
Formula Help with Count Number of Vessel Turnaround Trips monthly based on Criteria
Replies
1
Views
479
Lukma
L
J
  • Solved
Difference between dates based on follow on work
Replies
5
Views
566
Alex Blakenburg
A

Forum statistics

Threads
1,224,822
Messages
6,181,164
Members
453,021
Latest member
Justyna P

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