How to summarise multiple entries of data using VB code?

Sebastian

New Member
Joined
Sep 17, 2002
Messages
32
The spreadsheet shows a number of entries of various products. Some of the products have multiple entries.
Bulletin Board stuff.xls
ABCDEFG
1DATEPARTNUMBERPARTNAMECUSTOMERQUANTITY$Price$VALUE
230/08/022683Product1Customer11,380$0.6146$848.15
305/08/0220072Product2Customer288$0.7377$64.92
430/08/0220072Product2Customer2715$0.7377$527.46
505/08/0220073Product3Customer2563$0.7046$396.69
615/08/022290313Product4Customer31$7.1633$7.16
715/08/022290315Product5Customer33$4.7733$14.32
815/08/022290313Product4Customer317$7.1633$121.78
926/08/026200142Product6Customer326$2.7602$71.77
1026/08/022290313Product4Customer34$7.1633$28.65
1126/08/026200154Product7Customer32$9.9926$19.99
1226/08/022290315Product5Customer321$4.7733$100.24
1331/07/020038-400-565Product8Customer440$10.1076$404.30
1414/08/0220072Product2Customer2543$0.7377$400.57
1526/08/0220073Product3Customer2138$0.7046$97.23
1614/08/0220073Product3Customer2732$0.7046$515.77
1706/08/024302-047-00130Product9Customer546$0.1210$5.57
1826/07/024302-047-00130Product9Customer53,000$0.1210$363.00
1919/08/024302-047-1790Product10Customer54$0.8193$3.28
2019/08/024302-047-21780Product11Customer5142$0.7430$105.51
2119/08/024302-047-1790Product10Customer529$0.8193$23.76
2219/08/024302-047-1790Product10Customer54$0.8193$3.28
237,498$4,123.38
Sheet1



What I need to do is add the multiple entries so I end up with a single entry per product as below (The date column can be disregarded)<SCRIPT language=JavaScript src="http://www.interq.or.jp/sun/puremis/colo/popup.js"></SCRIPT><CENTER><TABLE cellSpacing=0 cellPadding=0 align=center><TBODY><TR><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid" bgColor=#0c266b colSpan=8><TABLE width="100%" align=center border=0><TBODY><TR><TD align=left><FONT color=white>Microsoft Excel - Bulletin Board stuff.xls</FONT></TD><TD style="FONT-SIZE: 9pt; COLOR: #ffffff; FONT-FAMILY: caption" align=right>___Running: xl2002 XP : OS = Windows XP</FONT></TD></TR></TBODY></TABLE></TD></TR><TR><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid; HEIGHT: 25px" bgColor=#d4d0c8 colSpan=8><TABLE width="100%" align=center border=0 VALIGN="MIDDLE"><TBODY><TR><TD style="FONT-SIZE: 10pt; COLOR: #000000; FONT-FAMILY: caption">(<U>F</U>)ile (<U>E</U>)dit (<U>V</U>)iew (<U>I</U>)nsert (<U>O</U>)ptions (<U>T</U>)ools (<U>D</U>)ata (<U>W</U>)indow (<U>H</U>)elp (<U>A</U>)bout</TD><TD vAlign=center align=right><FORM name=formCb658016><INPUT onclick='window.clipboardData.setData("Text",document.formFb431795.sltNb305190.value);' type=button value="Copy Formula" name=btCb074442></FORM></TD></TR></TBODY></TABLE></TD></TR><TR><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid" bgColor=white colSpan=8><TABLE border=0><TBODY><TR><FORM name=formFb431795><TD style="WIDTH: 60px" align=middle bgColor=white><SELECT onchange="document.formFb431795.txbFb428726.value = document.formFb431795.sltNb305190.value" name=sltNb305190><OPTION value==E27*F27 selected>G27<OPTION value==E28*F28>G28<OPTION value==E29*F29>G29<OPTION value==E30*F30>G30<OPTION value==E31*F31>G31<OPTION value==E32*F32>G32<OPTION value==E33*F33>G33<OPTION value==E34*F34>G34<OPTION value==E35*F35>G35<OPTION value==E36*F36>G36<OPTION value==E37*F37>G37<OPTION value==SUM(E27:E37)>E38<OPTION value==SUM(G27:G37)>G38</OPTION></SELECT></TD><TD align=right width="3%" bgColor=#d4d0c8>=</TD><TD align=left bgColor=white><INPUT size=80 value==E27*F27 name=txbFb428726></TD></FORM></TR></TBODY></TABLE></TD></TR><TR><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>A</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>B</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>C</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>D</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>E</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>F</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>G</CENTER></TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"><CENTER>26</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #000000 2pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">DATE</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 2pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">PART NUMBER</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 2pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">PART NAME</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #000000 2pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">CUSTOMER</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 2pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">QUANTITY</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 2pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"> $ Price </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 2pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"> $ VALUE  </TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"><CENTER>27</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">30/08/02</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">2683</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">Product 1</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">Customer1</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">1,380</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"> $      0.6146 </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"> $         848.15 </FONT></TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"><CENTER>28</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">05/08/02</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">20072</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">Product 2</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">Customer2</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">1,346</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"> $      0.7377 </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"> $         992.94 </FONT></TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"><CENTER>29</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">05/08/02</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">20073</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">Product 3</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">Customer2</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">1,433</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"> $      0.7046 </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"> $      1,009.69 </FONT></TD></TR><TR><TD style="BORDER-TOP: #000000
 

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

Sebastian

New Member
Joined
Sep 17, 2002
Messages
32
Ooops. Don't know what happened there.
The second table should look like this
Bulletin Board stuff.xls
ABCDEFG
26DATEPARTNUMBERPARTNAMECUSTOMERQUANTITY$Price$VALUE
2730/08/022683Product1Customer11,380$0.6146$848.15
2805/08/0220072Product2Customer21,346$0.7377$992.94
2905/08/0220073Product3Customer21,433$0.7046$1,009.69
3015/08/022290313Product4Customer322$7.1633$157.59
3115/08/022290315Product5Customer324$4.7733$114.56
3226/08/026200142Product6Customer326$2.7602$71.77
3326/08/026200154Product7Customer32$9.9926$19.99
3431/07/020038-400-565Product8Customer440$10.1076$404.30
3506/08/024302-047-00130Product9Customer53,046$0.1210$368.57
3619/08/024302-047-1790Product10Customer537$0.8193$30.31
3719/08/024302-047-21780Product11Customer5142$0.7430$105.51
387,498$4,123.38
Sheet1



Can it be done using VB code?
 

stevebausch

Well-known Member
Joined
May 11, 2002
Messages
810
Okay, "you want to consolidate multiple entries". After sorting on what? Part Number? Customer? Part Name? Or a combination of all three, and in what sequence?

While doing so, you need to sum up columns E,F,G. Or, maybe not....

Actually, I am so confused. Having it displayed on two monitors, for comparision, didn't help, either.

Let's present this challenge my way, which is sequential:

Column A, the date: Keep the most recent date?
Column B, part number: unique identifier, having multiple citations of the same part number is what you want to eliminate.

Column C, part name: if there is a duplicate part number in the list, the duplicate part name is exactly the same in both rows, right?

Column D, Customer: sort on customer, before consolidating entries?

Column E, Quantity: after sorting on customer, sum up each customer's quantity.

Column F, Price: customers may have different prices quoted, don't lose the relationship.

Column G, Value: After sorting on customer, sum up the cumulative value of each part's purchase history.

Are any of these assumptions correct?
This message was edited by stevebausch on 2002-10-09 04:19
 

Sebastian

New Member
Joined
Sep 17, 2002
Messages
32
On 2002-10-09 04:15, stevebausch wrote:
Okay, "you want to consolidate multiple entries". After sorting on what? Part Number? Customer? Part Name? Or a combination of all three, and in what sequence?

While doing so, you need to sum up columns E,F,G. Or, maybe not....

Actually, I am so confused. Having it displayed on two monitors, for comparision, didn't help, either.

Let's present this challenge my way, which is sequential:

Column A, the date: Keep the most recent date? (Sebastian) The date doesn't matter.
Column B, part number: unique identifier, having multiple citations of the same part number is what you want to eliminate.

Column C, part name: if there is a duplicate part number in the list, the duplicate part name is exactly the same in both rows, right?
(Sebastian) That's correct.

Column D, Customer: sort on customer, before consolidating entries? (Sebastian) Not necessary.

Column E, Quantity: after sorting on customer, sum up each customer's quantity. (Sebastian) No, I need to sum up each product's quantity so at the end I have one entry of each product.

Column F, Price: customers may have different prices quoted, don't lose the relationship. (Sebastian) Each product has one price. The relationship between product and customer is one to one. ie. Product 3 belongs to Customer 2 and nobody else.

Column G, Value: After sorting on customer, sum up the cumulative value of each part's purchase history. (Sebastian) No.

Are any of these assumptions correct?

Firstly my apologies for a delayed reply. I posted the original question few hours ago when I was still at work.

I suppose I wasn't very clear with my explanations.
What I use the table for is - after all the calculations, I sort descending by column G (Value) and display top ten products on a chart.

That's why I need only one entry per product. For example: last month there were three entries for Product 3 (563, 138 and 732). I would add the quantities up, type the sum (1433) in one of the rows, overwriting the old entry and delete the other two. So when you you look at the total sum of column E it's the same in both tables.

Does that make any sense?
This message was edited by stevebausch on 2002-10-09 04:19
 

stevebausch

Well-known Member
Joined
May 11, 2002
Messages
810

ADVERTISEMENT

:biggrin: Excellent!

One reason I asked all the questions, is I don't know all the answers; others do, but we needed to make it easy for others to participate. My current strength is VBA, chances are Excel has features to handle your needs, without VBA. Chances are I don't know those features, yet :)


To reiterate:

Column A, the date:The date doesn't matter.

Column B, having multiple citations of the same part number is what you want to eliminate.

Column C, part name: duplicate part names are exactly the same? That's correct.

Column D, Customer: sort on customer Not necessary.

Column E, Quantity: I need to sum up each product's quantity so at the end I have one entry of each product.

Column F, Price: Each product has one price. The relationship between product and customer is one to one. ie. Product 3 belongs to Customer 2 and nobody else.

Column G, Value: Total of purchases, for the respective part number.


What I use the table for is - after all the calculations, I sort descending by column G (Value) and display top ten products on a chart.


I need only one entry per product.

For example: last month there were three entries for Product 3 (563, 138 and 732). I would add the quantities up, type the sum (1433) in one of the rows, overwriting the old entry and delete the other two. So when you you look at the total sum of column E it's the same in both tables.
 

ThePencilQueen

Board Regular
Joined
Jun 26, 2002
Messages
109
Create a pivot table with product in the row section and sum of quantity in the data section.
 

Sebastian

New Member
Joined
Sep 17, 2002
Messages
32
How easy it is to overlook the simple solutions. Thanks Pencil Queen.
I can now record a macro that will create a pivot table automatically.
 

Forum statistics

Threads
1,144,273
Messages
5,723,437
Members
422,497
Latest member
dougy99

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