Removing duplicates and adding amounts

Ramballah

Ramballah

Active Member
Joined
Sep 25, 2018
Messages
332
Office Version
  1. 365
Platform
  1. Windows
Hi,

So the past weeks I've been making a new workbook for work and received amazing help from the people of this community.
And right now I'm on my last puzzle!

I have this power query that reformats information from the raw data for me and works wonders (power query is because the data is dynamic as I add new rows of data every week)
And now I need to have a second table right next to it to basically tell me which items have the highest amount, and tell me how many times each item appeared.
Here is the example:
I have this:
DateWkCodeNameAmount Totaal TypeGroup
22/07/20243023077BLIJKI VRIJ UITL OMEGA 35€ 13,65OvercodeEieren
22/07/202430432527OPTIME DRINK BANAAN 1L1€ 1,99OvercodeDrink
22/07/202430178334DANONE SPRINKLINS 2P1€ 1,89OvercodeEet
22/07/202430209076ARLA LACTOFREE HV YOGHURT2€ 4,50OvercodeEet
22/07/202430499687I SKYR SKYR TOP CARAMEL2€ 5,46OvercodeN.V.T.
22/07/202430578882DANONE M&M YOGHURT4€ 4,52OvercodeEet
23/07/20243065689OPTIME DRINK AARDB/KERS1€ 1,95OvercodeDrink
23/07/20243074004CAMPIN HV MELK 2.4 L1€ 2,90OvercodeDrink
23/07/202430347824OPTIME DRINK AARDBKERS1.52€ 5,12OvercodeDrink
23/07/202430347825OPTIME DRINK FRAMBS 1.5L1€ 2,61OvercodeDrink
23/07/202430594245ACTIME SINAASAPPEL 4PK9€ 21,06OvercodeDrink
23/07/202430121010MONA PUDDING TOETJE VDM2€ 5,08OvercodeEet
23/07/202430174433LINDAHLS KVARG VANILLE2€ 5,30OvercodeEet
23/07/202430193264JUMBO KNIJPKWRK AARDB 4P1€ 1,57OvercodeEet
23/07/202430576940EHRMANN PROT PUDD CARAMEL5€ 8,60OvercodeEet
23/07/202430576944EHRMANN PROT PUD CHOC TOP1€ 1,79OvercodeEet
23/07/202430577924ALMHOF HOEKJE VENETIE3€ 4,14OvercodeEet
23/07/202430578379ZHOEVE PROT TOP YOG AARDB2€ 3,50OvercodeEet
23/07/202430603216ALPRO PROT YOGH TROPICAL6€ 11,58OvercodeEet
23/07/202430603217ALPRO PROT YOGH ROODFRUIT12€ 23,16OvercodeEet
23/07/202430610577JUMBO SLAGROOM 35% 125ML2€ 1,98OvercodeEet
23/07/202430388397JUMBO KWARK VANILLE1€ 1,89BreukEet
24/07/202430610412SCHARREL EI WIT 301€ 6,31OvercodeEieren
24/07/20243031677CAMPIN HALFVOLLE MILDE YO1€ 1,64OvercodeEet
24/07/202430221285JUMBO BIOGARDE ROERYOGH1€ 1,39OvercodeEet
24/07/202430221285JUMBO BIOGARDE ROERYOGH1€ 1,39OvercodeEet
24/07/202430347423CAMPIN KWARK MAGER AARDB1€ 1,99OvercodeEet
24/07/202430388396JUMBO KWARK AARDBEI2€ 2,98OvercodeEet
24/07/202430526979CAMPIN VLA CHOCO1€ 1,89OvercodeEet
24/07/202430526979CAMPIN VLA CHOCO1€ 1,89OvercodeEet
24/07/202430578747JUMBO VLAATJE DUBBEL2€ 2,78OvercodeEet
24/07/202430580961VIFIT DRINK BOSVRUCHTEN3€ 4,47OvercodeEet
24/07/202430593943MELKUN PROT KWARK VANILLE2€ 2,98OvercodeEet
24/07/202430102408MELKUN HAVERMOUTPAP1€ 2,19BreukEet
24/07/202430311924NEUTR CREME FRAICHE 30%1€ 0,99BreukEet
24/07/202430578747JUMBO VLAATJE DUBBEL1€ 1,39BreukEet
24/07/202430347423CAMPIN KWARK MAGER AARDB1€ 1,99BederfEet
25/07/202430605273JUMBO GEKOOKT 2 STK2€ 1,98OvercodeEieren
25/07/202430420594JUMBO BIO VOLLE MELK 1L1€ 1,39OvercodeDrink
25/07/202430376106JUMBO VANILLE YOGHURT1€ 1,62OvercodeEet
25/07/202430577759MELKUN PROT PUDD SALT CAR1€ 1,66OvercodeEet
25/07/202430577759MELKUN PROT PUDD SALT CAR1€ 1,66OvercodeEet
25/07/202430578077ZHOEVE BOER N YOGH MU BOS4€ 6,80OvercodeEet
25/07/202430612024ZHOEVE BOERN YOGH HAGELSL3€ 5,25OvercodeEet
26/07/202430602972JUMBO GEKLEURDE EIEREN 61€ 2,49OvercodeEieren
26/07/202430610397JUMBO SCHARREL L/XL 101€ 4,05BreukEieren
26/07/202430198297OPTIME DRINK AARDBEI 1L6€ 11,34OvercodeDrink
26/07/202430501100JUMBO HV MELK 1.5L BLK4€ 6,64BreukDrink
26/07/202430501100JUMBO HV MELK 1.5L BLK1€ 1,66BreukDrink

Which is only 50 rows for now. And what I want is this:
CodeNameAmountTimesGroup
23077BLIJKI VRIJ UITL OMEGA 351Eieren
432527OPTIME DRINK BANAAN 1L11Drink
178334DANONE SPRINKLINS 2P11Eet
209076ARLA LACTOFREE HV YOGHURT21Eet
499687I SKYR SKYR TOP CARAMEL21N.V.T.
578882DANONE M&M YOGHURT41Eet
65689OPTIME DRINK AARDB/KERS11Drink
74004CAMPIN HV MELK 2.4 L11Drink
347824OPTIME DRINK AARDBKERS1.521Drink
347825OPTIME DRINK FRAMBS 1.5L11Drink
594245ACTIME SINAASAPPEL 4PK91Drink
121010MONA PUDDING TOETJE VDM21Eet
174433LINDAHLS KVARG VANILLE21Eet
193264JUMBO KNIJPKWRK AARDB 4P11Eet
576940EHRMANN PROT PUDD CARAMEL51Eet
576944EHRMANN PROT PUD CHOC TOP11Eet
577924ALMHOF HOEKJE VENETIE31Eet
578379ZHOEVE PROT TOP YOG AARDB21Eet
603216ALPRO PROT YOGH TROPICAL61Eet
603217ALPRO PROT YOGH ROODFRUIT121Eet
610577JUMBO SLAGROOM 35% 125ML21Eet
610412SCHARREL EI WIT 3011Eieren
31677CAMPIN HALFVOLLE MILDE YO11Eet
221285JUMBO BIOGARDE ROERYOGH22Eet
347423CAMPIN KWARK MAGER AARDB11Eet
388396JUMBO KWARK AARDBEI21Eet
526979CAMPIN VLA CHOCO22Eet
578747JUMBO VLAATJE DUBBEL21Eet
580961VIFIT DRINK BOSVRUCHTEN31Eet
593943MELKUN PROT KWARK VANILLE21Eet
605273JUMBO GEKOOKT 2 STK21Eieren
420594JUMBO BIO VOLLE MELK 1L11Drink
376106JUMBO VANILLE YOGHURT11Eet
577759MELKUN PROT PUDD SALT CAR22Eet
578077ZHOEVE BOER N YOGH MU BOS41Eet
612024ZHOEVE BOERN YOGH HAGELSL31Eet
602972JUMBO GEKLEURDE EIEREN 611Eieren
198297OPTIME DRINK AARDBEI 1L61Drink

It counts how many times certain items are found, so some items are found twice and adds up those qty amounts. Even singular appearances get in this 2nd table. Also, its only for the items with the type "Overcode". I don't need this for the other types only for this. This allows me to find which items are being trashed the most, and which are trashed often.
I also don't care if this is with formulas or power query or macro's. It's my own workbook! I hope this information is enough, if not feel free to ask!
Thanks in advance,
Ramballah

*edit* added a picture for reference, and some items appear like 5-10 times with different amount, in this example it just happened that only a few appeared multiple times with only 1 on the amount column. So the amounts can be 5+7 aswell for example!
1725302519457.png
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.
Sort by date Sort by votes
How about
Fluff.xlsm
ABCDEFGHIJKLMN
1DateWkCodeNameAmount Totaal TypeGroup
2454953023077BLIJKI VRIJ UITL OMEGA 3513.65OvercodeEieren23077BLIJKI VRIJ UITL OMEGA 351Eieren
34549530432527OPTIME DRINK BANAAN 1L11.99OvercodeDrink432527OPTIME DRINK BANAAN 1L11Drink
44549530178334DANONE SPRINKLINS 2P11.89OvercodeEet178334DANONE SPRINKLINS 2P11Eet
54549530209076ARLA LACTOFREE HV YOGHURT24.5OvercodeEet209076ARLA LACTOFREE HV YOGHURT21Eet
64549530499687I SKYR SKYR TOP CARAMEL25.46OvercodeN.V.T.499687I SKYR SKYR TOP CARAMEL21N.V.T.
74549530578882DANONE M&M YOGHURT44.52OvercodeEet578882DANONE M&M YOGHURT41Eet
8454963065689OPTIME DRINK AARDB/KERS11.95OvercodeDrink65689OPTIME DRINK AARDB/KERS11Drink
9454963074004CAMPIN HV MELK 2.4 L12.9OvercodeDrink74004CAMPIN HV MELK 2.4 L11Drink
104549630347824OPTIME DRINK AARDBKERS1.525.12OvercodeDrink347824OPTIME DRINK AARDBKERS1.521Drink
114549630347825OPTIME DRINK FRAMBS 1.5L12.61OvercodeDrink347825OPTIME DRINK FRAMBS 1.5L11Drink
124549630594245ACTIME SINAASAPPEL 4PK921.06OvercodeDrink594245ACTIME SINAASAPPEL 4PK91Drink
134549630121010MONA PUDDING TOETJE VDM25.08OvercodeEet121010MONA PUDDING TOETJE VDM21Eet
144549630174433LINDAHLS KVARG VANILLE25.3OvercodeEet174433LINDAHLS KVARG VANILLE21Eet
154549630193264JUMBO KNIJPKWRK AARDB 4P11.57OvercodeEet193264JUMBO KNIJPKWRK AARDB 4P11Eet
164549630576940EHRMANN PROT PUDD CARAMEL58.6OvercodeEet576940EHRMANN PROT PUDD CARAMEL51Eet
174549630576944EHRMANN PROT PUD CHOC TOP11.79OvercodeEet576944EHRMANN PROT PUD CHOC TOP11Eet
184549630577924ALMHOF HOEKJE VENETIE34.14OvercodeEet577924ALMHOF HOEKJE VENETIE31Eet
194549630578379ZHOEVE PROT TOP YOG AARDB23.5OvercodeEet578379ZHOEVE PROT TOP YOG AARDB21Eet
204549630603216ALPRO PROT YOGH TROPICAL611.58OvercodeEet603216ALPRO PROT YOGH TROPICAL61Eet
214549630603217ALPRO PROT YOGH ROODFRUIT1223.16OvercodeEet603217ALPRO PROT YOGH ROODFRUIT121Eet
224549630610577JUMBO SLAGROOM 35% 125ML21.98OvercodeEet610577JUMBO SLAGROOM 35% 125ML21Eet
234549630388397JUMBO KWARK VANILLE11.89BreukEet610412SCHARREL EI WIT 3011Eieren
244549730610412SCHARREL EI WIT 3016.31OvercodeEieren31677CAMPIN HALFVOLLE MILDE YO11Eet
25454973031677CAMPIN HALFVOLLE MILDE YO11.64OvercodeEet221285JUMBO BIOGARDE ROERYOGH22Eet
264549730221285JUMBO BIOGARDE ROERYOGH11.39OvercodeEet347423CAMPIN KWARK MAGER AARDB22Eet
274549730221285JUMBO BIOGARDE ROERYOGH11.39OvercodeEet388396JUMBO KWARK AARDBEI21Eet
284549730347423CAMPIN KWARK MAGER AARDB11.99OvercodeEet526979CAMPIN VLA CHOCO22Eet
294549730388396JUMBO KWARK AARDBEI22.98OvercodeEet578747JUMBO VLAATJE DUBBEL32Eet
304549730526979CAMPIN VLA CHOCO11.89OvercodeEet580961VIFIT DRINK BOSVRUCHTEN31Eet
314549730526979CAMPIN VLA CHOCO11.89OvercodeEet593943MELKUN PROT KWARK VANILLE21Eet
324549730578747JUMBO VLAATJE DUBBEL22.78OvercodeEet605273JUMBO GEKOOKT 2 STK21Eieren
334549730580961VIFIT DRINK BOSVRUCHTEN34.47OvercodeEet420594JUMBO BIO VOLLE MELK 1L11Drink
344549730593943MELKUN PROT KWARK VANILLE22.98OvercodeEet376106JUMBO VANILLE YOGHURT11Eet
354549730102408MELKUN HAVERMOUTPAP12.19BreukEet577759MELKUN PROT PUDD SALT CAR22Eet
364549730311924NEUTR CREME FRAICHE 30%10.99BreukEet578077ZHOEVE BOER N YOGH MU BOS41Eet
374549730578747JUMBO VLAATJE DUBBEL11.39BreukEet612024ZHOEVE BOERN YOGH HAGELSL31Eet
384549730347423CAMPIN KWARK MAGER AARDB11.99BederfEet602972JUMBO GEKLEURDE EIEREN 611Eieren
394549830605273JUMBO GEKOOKT 2 STK21.98OvercodeEieren198297OPTIME DRINK AARDBEI 1L61Drink
404549830420594JUMBO BIO VOLLE MELK 1L11.39OvercodeDrink
414549830376106JUMBO VANILLE YOGHURT11.62OvercodeEet
424549830577759MELKUN PROT PUDD SALT CAR11.66OvercodeEet
434549830577759MELKUN PROT PUDD SALT CAR11.66OvercodeEet
444549830578077ZHOEVE BOER N YOGH MU BOS46.8OvercodeEet
454549830612024ZHOEVE BOERN YOGH HAGELSL35.25OvercodeEet
464549930602972JUMBO GEKLEURDE EIEREN 612.49OvercodeEieren
474549930610397JUMBO SCHARREL L/XL 1014.05BreukEieren
484549930198297OPTIME DRINK AARDBEI 1L611.34OvercodeDrink
494549930501100JUMBO HV MELK 1.5L BLK46.64BreukDrink
504549930501100JUMBO HV MELK 1.5L BLK11.66BreukDrink
Data
Cell Formulas
RangeFormula
J2:N39J2=LET(u,UNIQUE(FILTER(CHOOSECOLS(Table2[[Code]:[Group]],1,2,-1),Table2[Type]="overcode")),HSTACK(TAKE(u,,2),SUMIFS(Table2[Amount],Table2[Code],INDEX(u,,1)),COUNTIFS(Table2[Code],INDEX(u,,1)),TAKE(u,,-1)))
Dynamic array formulas.
 
Upvote 0
Fluff said:
How about
Fluff.xlsm
ABCDEFGHIJKLMN
1DateWkCodeNameAmount Totaal TypeGroup
2454953023077BLIJKI VRIJ UITL OMEGA 3513.65OvercodeEieren23077BLIJKI VRIJ UITL OMEGA 351Eieren
34549530432527OPTIME DRINK BANAAN 1L11.99OvercodeDrink432527OPTIME DRINK BANAAN 1L11Drink
44549530178334DANONE SPRINKLINS 2P11.89OvercodeEet178334DANONE SPRINKLINS 2P11Eet
54549530209076ARLA LACTOFREE HV YOGHURT24.5OvercodeEet209076ARLA LACTOFREE HV YOGHURT21Eet
64549530499687I SKYR SKYR TOP CARAMEL25.46OvercodeN.V.T.499687I SKYR SKYR TOP CARAMEL21N.V.T.
74549530578882DANONE M&M YOGHURT44.52OvercodeEet578882DANONE M&M YOGHURT41Eet
8454963065689OPTIME DRINK AARDB/KERS11.95OvercodeDrink65689OPTIME DRINK AARDB/KERS11Drink
9454963074004CAMPIN HV MELK 2.4 L12.9OvercodeDrink74004CAMPIN HV MELK 2.4 L11Drink
104549630347824OPTIME DRINK AARDBKERS1.525.12OvercodeDrink347824OPTIME DRINK AARDBKERS1.521Drink
114549630347825OPTIME DRINK FRAMBS 1.5L12.61OvercodeDrink347825OPTIME DRINK FRAMBS 1.5L11Drink
124549630594245ACTIME SINAASAPPEL 4PK921.06OvercodeDrink594245ACTIME SINAASAPPEL 4PK91Drink
134549630121010MONA PUDDING TOETJE VDM25.08OvercodeEet121010MONA PUDDING TOETJE VDM21Eet
144549630174433LINDAHLS KVARG VANILLE25.3OvercodeEet174433LINDAHLS KVARG VANILLE21Eet
154549630193264JUMBO KNIJPKWRK AARDB 4P11.57OvercodeEet193264JUMBO KNIJPKWRK AARDB 4P11Eet
164549630576940EHRMANN PROT PUDD CARAMEL58.6OvercodeEet576940EHRMANN PROT PUDD CARAMEL51Eet
174549630576944EHRMANN PROT PUD CHOC TOP11.79OvercodeEet576944EHRMANN PROT PUD CHOC TOP11Eet
184549630577924ALMHOF HOEKJE VENETIE34.14OvercodeEet577924ALMHOF HOEKJE VENETIE31Eet
194549630578379ZHOEVE PROT TOP YOG AARDB23.5OvercodeEet578379ZHOEVE PROT TOP YOG AARDB21Eet
204549630603216ALPRO PROT YOGH TROPICAL611.58OvercodeEet603216ALPRO PROT YOGH TROPICAL61Eet
214549630603217ALPRO PROT YOGH ROODFRUIT1223.16OvercodeEet603217ALPRO PROT YOGH ROODFRUIT121Eet
224549630610577JUMBO SLAGROOM 35% 125ML21.98OvercodeEet610577JUMBO SLAGROOM 35% 125ML21Eet
234549630388397JUMBO KWARK VANILLE11.89BreukEet610412SCHARREL EI WIT 3011Eieren
244549730610412SCHARREL EI WIT 3016.31OvercodeEieren31677CAMPIN HALFVOLLE MILDE YO11Eet
25454973031677CAMPIN HALFVOLLE MILDE YO11.64OvercodeEet221285JUMBO BIOGARDE ROERYOGH22Eet
264549730221285JUMBO BIOGARDE ROERYOGH11.39OvercodeEet347423CAMPIN KWARK MAGER AARDB22Eet
274549730221285JUMBO BIOGARDE ROERYOGH11.39OvercodeEet388396JUMBO KWARK AARDBEI21Eet
284549730347423CAMPIN KWARK MAGER AARDB11.99OvercodeEet526979CAMPIN VLA CHOCO22Eet
294549730388396JUMBO KWARK AARDBEI22.98OvercodeEet578747JUMBO VLAATJE DUBBEL32Eet
304549730526979CAMPIN VLA CHOCO11.89OvercodeEet580961VIFIT DRINK BOSVRUCHTEN31Eet
314549730526979CAMPIN VLA CHOCO11.89OvercodeEet593943MELKUN PROT KWARK VANILLE21Eet
324549730578747JUMBO VLAATJE DUBBEL22.78OvercodeEet605273JUMBO GEKOOKT 2 STK21Eieren
334549730580961VIFIT DRINK BOSVRUCHTEN34.47OvercodeEet420594JUMBO BIO VOLLE MELK 1L11Drink
344549730593943MELKUN PROT KWARK VANILLE22.98OvercodeEet376106JUMBO VANILLE YOGHURT11Eet
354549730102408MELKUN HAVERMOUTPAP12.19BreukEet577759MELKUN PROT PUDD SALT CAR22Eet
364549730311924NEUTR CREME FRAICHE 30%10.99BreukEet578077ZHOEVE BOER N YOGH MU BOS41Eet
374549730578747JUMBO VLAATJE DUBBEL11.39BreukEet612024ZHOEVE BOERN YOGH HAGELSL31Eet
384549730347423CAMPIN KWARK MAGER AARDB11.99BederfEet602972JUMBO GEKLEURDE EIEREN 611Eieren
394549830605273JUMBO GEKOOKT 2 STK21.98OvercodeEieren198297OPTIME DRINK AARDBEI 1L61Drink
404549830420594JUMBO BIO VOLLE MELK 1L11.39OvercodeDrink
414549830376106JUMBO VANILLE YOGHURT11.62OvercodeEet
424549830577759MELKUN PROT PUDD SALT CAR11.66OvercodeEet
434549830577759MELKUN PROT PUDD SALT CAR11.66OvercodeEet
444549830578077ZHOEVE BOER N YOGH MU BOS46.8OvercodeEet
454549830612024ZHOEVE BOERN YOGH HAGELSL35.25OvercodeEet
464549930602972JUMBO GEKLEURDE EIEREN 612.49OvercodeEieren
474549930610397JUMBO SCHARREL L/XL 1014.05BreukEieren
484549930198297OPTIME DRINK AARDBEI 1L611.34OvercodeDrink
494549930501100JUMBO HV MELK 1.5L BLK46.64BreukDrink
504549930501100JUMBO HV MELK 1.5L BLK11.66BreukDrink
Data
Cell Formulas
RangeFormula
J2:N39J2=LET(u,UNIQUE(FILTER(CHOOSECOLS(Table2[[Code]:[Group]],1,2,-1),Table2[Type]="overcode")),HSTACK(TAKE(u,,2),SUMIFS(Table2[Amount],Table2[Code],INDEX(u,,1)),COUNTIFS(Table2[Code],INDEX(u,,1)),TAKE(u,,-1)))
Dynamic array formulas.
Click to expand...
1725304235265.png
unsure if im doing it wrong, also How do we keep this dynamically? Right now my table is 325 rows, next week it will be like 400 rows, in 3 weeks prob around 600 etc
 
Upvote 0
another option with Power Query

Power Query: 
let
    Source = Excel.CurrentWorkbook(){[Name="Table2"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Date", type date}}),
    #"Grouped Rows" = Table.Group(#"Changed Type", {"Code", "Name", "Type"}, {{"Count", each Table.RowCount(_), Int64.Type}, {"Total", each List.Sum([Amount]), type number}})
in
    #"Grouped Rows"

which will update when new data is added to the source by selecting the Refresh All Icon on the Data Tab
 
Upvote 0
You need to change Table2 to the name of your table (Table4 by the looks of it) everywhere it occurs.
 
Upvote 0
alansidman said:
another option with Power Query

Power Query: 
let
    Source = Excel.CurrentWorkbook(){[Name="Table2"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Date", type date}}),
    #"Grouped Rows" = Table.Group(#"Changed Type", {"Code", "Name", "Type"}, {{"Count", each Table.RowCount(_), Int64.Type}, {"Total", each List.Sum([Amount]), type number}})
in
    #"Grouped Rows"

which will update when new data is added to the source by selecting the Refresh All Icon on the Data Tab
Click to expand...
How exactly do I implement this? I Cannot press From Table/Range as my table is made by power query so I dont know how to add a new power query with this code
 
Upvote 0
If you already have a table in power Query, then apply the steps after Source to your existing query. You may not need to change the format as I was taking and copying the data you provided and that was needed. You may probably only need to apply the GroupBy functionality in PQ.
 
Upvote 0
alansidman said:
If you already have a table in power Query, then apply the steps after Source to your existing query. You may not need to change the format as I was taking and copying the data you provided and that was needed. You may probably only need to apply the GroupBy functionality in PQ.
Click to expand...
Well, my table on the left is with power query and i need this new table on the right. I tried adding ur code to my power query table which is on the left but i get this:
1725306430641.png

but even if we fix this issue ^, i need it in a new table so I can filter and sort
 
Upvote 0
Try changing the u (everywhere it occurs) to something else, maybe Data
 
Upvote 0
You must log in or register to reply here.

Similar threads

Ramballah
  • Question
Transferring raw data into my own sheet
Replies
7
Views
245
Kerryx
K

Forum statistics

Threads
1,221,469
Messages
6,160,027
Members
451,611
Latest member
PattiButche

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