Record Count for each Record

gpouliot

New Member
Joined
Jan 19, 2009
Messages
39
Hi,

I have two tables each record line in each table is identical in table 1 and table 2 just with different data.

I would like to create a query to have a count for each records. So I could then create query matching my count# on each table to manipulate my data.

Current Query Data
<TABLE border=1 cellSpacing=0 bgColor=#ffffff><CAPTION>PARTTRAN</CAPTION><THEAD><TR><TH bgColor=#c0c0c0 borderColor=#000000>part_number</TH><TH bgColor=#c0c0c0 borderColor=#000000>ship_to_code</TH><TH bgColor=#c0c0c0 borderColor=#000000>employee_number</TH><TH bgColor=#c0c0c0 borderColor=#000000>Pcs</TH><TH bgColor=#c0c0c0 borderColor=#000000>transaction_date</TH></TR></THEAD><TBODY><TR vAlign=top><TD borderColor=#d0d7e5>544P24143</TD><TD borderColor=#d0d7e5>QJ</TD><TD borderColor=#d0d7e5>039796</TD><TD borderColor=#d0d7e5 align=right>1</TD><TD borderColor=#d0d7e5>20100804</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>544P24143</TD><TD borderColor=#d0d7e5>QJ</TD><TD borderColor=#d0d7e5>030953</TD><TD borderColor=#d0d7e5 align=right>1</TD><TD borderColor=#d0d7e5>20100804</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>544P24185</TD><TD borderColor=#d0d7e5>QJ</TD><TD borderColor=#d0d7e5>050137</TD><TD borderColor=#d0d7e5 align=right>1</TD><TD borderColor=#d0d7e5>20100804</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>544P24143</TD><TD borderColor=#d0d7e5>QJ</TD><TD borderColor=#d0d7e5>058236</TD><TD borderColor=#d0d7e5 align=right>1</TD><TD borderColor=#d0d7e5>20100804</TD></TR></TBODY><TFOOT></TFOOT></TABLE>

Desired Query Data
<TABLE style="WIDTH: 367pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=489><COLGROUP><COL style="WIDTH: 33pt; mso-width-source: userset; mso-width-alt: 1609" width=44><COL style="WIDTH: 66pt; mso-width-source: userset; mso-width-alt: 3218" width=88><COL style="WIDTH: 68pt; mso-width-source: userset; mso-width-alt: 3291" width=90><COL style="WIDTH: 96pt; mso-width-source: userset; mso-width-alt: 4681" width=128><COL style="WIDTH: 20pt; mso-width-source: userset; mso-width-alt: 987" width=27><COL style="WIDTH: 84pt; mso-width-source: userset; mso-width-alt: 4096" width=112><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: yellow; WIDTH: 33pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl71 height=20 width=44>Count</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #eeece1; WIDTH: 66pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl70 width=88>part_number</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #eeece1; WIDTH: 68pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl70 width=90>ship_to_code</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #eeece1; WIDTH: 96pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl70 width=128>employee_number</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #eeece1; WIDTH: 20pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl70 width=27>Pcs</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #eeece1; WIDTH: 84pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl70 width=112>transaction_date</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: yellow; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl71 height=20 align=right>1</TD><TD style="BORDER-BOTTOM: silver 0.5pt solid; BORDER-LEFT: silver 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 66pt; BORDER-TOP: silver 0.5pt solid; BORDER-RIGHT: silver 0.5pt solid" class=xl68 width=88>544P24143</TD><TD style="BORDER-BOTTOM: silver 0.5pt solid; BORDER-LEFT: silver; BACKGROUND-COLOR: transparent; WIDTH: 68pt; BORDER-TOP: silver 0.5pt solid; BORDER-RIGHT: silver 0.5pt solid" class=xl68 width=90>QJ</TD><TD style="BORDER-BOTTOM: silver 0.5pt solid; BORDER-LEFT: silver; BACKGROUND-COLOR: transparent; WIDTH: 96pt; BORDER-TOP: silver 0.5pt solid; BORDER-RIGHT: silver 0.5pt solid" class=xl68 width=128>039796</TD><TD style="BORDER-BOTTOM: silver 0.5pt solid; BORDER-LEFT: silver; BACKGROUND-COLOR: transparent; WIDTH: 20pt; BORDER-TOP: silver 0.5pt solid; BORDER-RIGHT: silver 0.5pt solid" class=xl69 width=27>1</TD><TD style="BORDER-BOTTOM: silver 0.5pt solid; BORDER-LEFT: silver; BACKGROUND-COLOR: transparent; WIDTH: 84pt; BORDER-TOP: silver 0.5pt solid; BORDER-RIGHT: silver 0.5pt solid" class=xl68 width=112>20100804</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: yellow; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl71 height=20 align=right>2</TD><TD style="BORDER-BOTTOM: silver 0.5pt solid; BORDER-LEFT: silver 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 66pt; BORDER-TOP: silver; BORDER-RIGHT: silver 0.5pt solid" class=xl68 width=88>544P24143</TD><TD style="BORDER-BOTTOM: silver 0.5pt solid; BORDER-LEFT: silver; BACKGROUND-COLOR: transparent; WIDTH: 68pt; BORDER-TOP: silver; BORDER-RIGHT: silver 0.5pt solid" class=xl68 width=90>QJ</TD><TD style="BORDER-BOTTOM: silver 0.5pt solid; BORDER-LEFT: silver; BACKGROUND-COLOR: transparent; WIDTH: 96pt; BORDER-TOP: silver; BORDER-RIGHT: silver 0.5pt solid" class=xl68 width=128>030953</TD><TD style="BORDER-BOTTOM: silver 0.5pt solid; BORDER-LEFT: silver; BACKGROUND-COLOR: transparent; WIDTH: 20pt; BORDER-TOP: silver; BORDER-RIGHT: silver 0.5pt solid" class=xl69 width=27>1</TD><TD style="BORDER-BOTTOM: silver 0.5pt solid; BORDER-LEFT: silver; BACKGROUND-COLOR: transparent; WIDTH: 84pt; BORDER-TOP: silver; BORDER-RIGHT: silver 0.5pt solid" class=xl68 width=112>20100804</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: yellow; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl71 height=20 align=right>3</TD><TD style="BORDER-BOTTOM: silver 0.5pt solid; BORDER-LEFT: silver 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 66pt; BORDER-TOP: silver; BORDER-RIGHT: silver 0.5pt solid" class=xl68 width=88>544P24185</TD><TD style="BORDER-BOTTOM: silver 0.5pt solid; BORDER-LEFT: silver; BACKGROUND-COLOR: transparent; WIDTH: 68pt; BORDER-TOP: silver; BORDER-RIGHT: silver 0.5pt solid" class=xl68 width=90>QJ</TD><TD style="BORDER-BOTTOM: silver 0.5pt solid; BORDER-LEFT: silver; BACKGROUND-COLOR: transparent; WIDTH: 96pt; BORDER-TOP: silver; BORDER-RIGHT: silver 0.5pt solid" class=xl68 width=128>050137</TD><TD style="BORDER-BOTTOM: silver 0.5pt solid; BORDER-LEFT: silver; BACKGROUND-COLOR: transparent; WIDTH: 20pt; BORDER-TOP: silver; BORDER-RIGHT: silver 0.5pt solid" class=xl69 width=27>1</TD><TD style="BORDER-BOTTOM: silver 0.5pt solid; BORDER-LEFT: silver; BACKGROUND-COLOR: transparent; WIDTH: 84pt; BORDER-TOP: silver; BORDER-RIGHT: silver 0.5pt solid" class=xl68 width=112>20100804</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: yellow; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl71 height=20 align=right>4</TD><TD style="BORDER-BOTTOM: silver 0.5pt solid; BORDER-LEFT: silver 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 66pt; BORDER-TOP: silver; BORDER-RIGHT: silver 0.5pt solid" class=xl68 width=88>544P24143</TD><TD style="BORDER-BOTTOM: silver 0.5pt solid; BORDER-LEFT: silver; BACKGROUND-COLOR: transparent; WIDTH: 68pt; BORDER-TOP: silver; BORDER-RIGHT: silver 0.5pt solid" class=xl68 width=90>QJ</TD><TD style="BORDER-BOTTOM: silver 0.5pt solid; BORDER-LEFT: silver; BACKGROUND-COLOR: transparent; WIDTH: 96pt; BORDER-TOP: silver; BORDER-RIGHT: silver 0.5pt solid" class=xl68 width=128>058236</TD><TD style="BORDER-BOTTOM: silver 0.5pt solid; BORDER-LEFT: silver; BACKGROUND-COLOR: transparent; WIDTH: 20pt; BORDER-TOP: silver; BORDER-RIGHT: silver 0.5pt solid" class=xl69 width=27>1</TD><TD style="BORDER-BOTTOM: silver 0.5pt solid; BORDER-LEFT: silver; BACKGROUND-COLOR: transparent; WIDTH: 84pt; BORDER-TOP: silver; BORDER-RIGHT: silver 0.5pt solid" class=xl68 width=112>20100804</TD></TR></TBODY></TABLE>

Any help would be greatly appreciated.

Thanks
 

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

tweedle

Well-known Member
Joined
Aug 1, 2010
Messages
1,559
You want a unique record identifier that ties the two tables together?
Looks like there should be an order number associated, and possibly another field that would be a record counter within the order? If so, those would be the 'keys'.
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,351
Office Version
  1. 365
Platform
  1. Windows
This doesn't really make much sense, are you sure it's a count you want?

What do you actually want to count in each table?

Can you post some sample data from the table(s)?
 

gpouliot

New Member
Joined
Jan 19, 2009
Messages
39
What I'm trying to do is link record 1 in table 1 to record 1 in table 2.
I have no key in each table to link them up. This is why I thought about creating a record count in a query for each table. Then I could link my two queries together and combine my data from each table.
 

tweedle

Well-known Member
Joined
Aug 1, 2010
Messages
1,559

ADVERTISEMENT

The only thing I could see to do would be flood a field with an Absolute position.
Doesn't seem like adding an Autonum would produce consistent results.

Have to really check that they are linking up the way you expect though!

Here's code if you want to see:
Add Field named 'AbsPos'.
Code:
Dim db As Database
Dim rs As Recordset
Set db = CurrentDb
 
'must be dynaset
Set rs = db.OpenRecordset("YourTableHere", dbOpenDynaset) 
With rs
    .MoveFirst
    Do While Not rs.EOF
    .Edit
        ![AbsPos] = rs.AbsolutePosition
    .Update
    .MoveNext
    Loop
End With
Set rs = Nothing
Set db = Nothing
 

james_lankford

Well-known Member
Joined
Jan 11, 2009
Messages
1,210
I think you just want to do a union query

select * from table_1
union
select * from table_2
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,351
Office Version
  1. 365
Platform
  1. Windows

ADVERTISEMENT

I really don't think using a count is a good idea for linking tables.

Are you certain there is no other way to uniquely identify the records?

Like james I was also thinking about a union query, perhaps with one addition - a new field indicating which table the record belongs to.

Once you've got that working it might be worth converting it to a table and investigating how things are setup.

eg why do you have 2 tables in the first place - are they structured the same, etc?
 

gpouliot

New Member
Joined
Jan 19, 2009
Messages
39
Here is a sample!

The only data I need to extract in PARTTRAN is Employee Number. I simply need to bring this data into SKIDSUM. Each records line in each table are a match and I have over 2,000 records in each tables. But I have no KEY to match the two table together (Maybe it not a coun i need to do).

Table: PARTTRAN
<TABLE border=1 cellSpacing=0 bgColor=#ffffff><CAPTION>PARTTRAN</CAPTION><THEAD><TR><TH bgColor=#c0c0c0 borderColor=#000000>part_number</TH><TH bgColor=#c0c0c0 borderColor=#000000>ship_to_code</TH><TH bgColor=#c0c0c0 borderColor=#000000>employee_number</TH><TH bgColor=#c0c0c0 borderColor=#000000>Pcs</TH><TH bgColor=#c0c0c0 borderColor=#000000>transaction_date</TH></TR></THEAD><TBODY><TR vAlign=top><TD borderColor=#d0d7e5>544P24143</TD><TD borderColor=#d0d7e5>QJ</TD><TD borderColor=#d0d7e5>039796</TD><TD borderColor=#d0d7e5 align=right>1</TD><TD borderColor=#d0d7e5>20100804</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>544P24143</TD><TD borderColor=#d0d7e5>QJ</TD><TD borderColor=#d0d7e5>030953</TD><TD borderColor=#d0d7e5 align=right>1</TD><TD borderColor=#d0d7e5>20100804</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>544P24185</TD><TD borderColor=#d0d7e5>QJ</TD><TD borderColor=#d0d7e5>050137</TD><TD borderColor=#d0d7e5 align=right>1</TD><TD borderColor=#d0d7e5>20100804</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>544P24143</TD><TD borderColor=#d0d7e5>QJ</TD><TD borderColor=#d0d7e5>058236</TD><TD borderColor=#d0d7e5 align=right>1</TD><TD borderColor=#d0d7e5>20100804</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>109R00752</TD><TD borderColor=#d0d7e5>QJ</TD><TD borderColor=#d0d7e5>008251</TD><TD borderColor=#d0d7e5 align=right>1</TD><TD borderColor=#d0d7e5>20100804</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>544P24143</TD><TD borderColor=#d0d7e5>QJ</TD><TD borderColor=#d0d7e5>062088</TD><TD borderColor=#d0d7e5 align=right>1</TD><TD borderColor=#d0d7e5>20100804</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>544P24143</TD><TD borderColor=#d0d7e5>QJ</TD><TD borderColor=#d0d7e5>051255</TD><TD borderColor=#d0d7e5 align=right>1</TD><TD borderColor=#d0d7e5>20100804</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>109R00752</TD><TD borderColor=#d0d7e5>QJ</TD><TD borderColor=#d0d7e5>010359</TD><TD borderColor=#d0d7e5 align=right>1</TD><TD borderColor=#d0d7e5>20100804</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>544P24143</TD><TD borderColor=#d0d7e5>QJ</TD><TD borderColor=#d0d7e5>999999</TD><TD borderColor=#d0d7e5 align=right>1</TD><TD borderColor=#d0d7e5>20100804</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>544P24143</TD><TD borderColor=#d0d7e5>QJ</TD><TD borderColor=#d0d7e5>051587</TD><TD borderColor=#d0d7e5 align=right>1</TD><TD borderColor=#d0d7e5>20100804</TD></TR></TBODY><TFOOT></TFOOT></TABLE>

Table: SKIDSUM
<TABLE border=1 cellSpacing=0 bgColor=#ffffff><CAPTION>SKIDSUM</CAPTION><THEAD><TR><TH bgColor=#c0c0c0 borderColor=#000000>ship_to_code</TH><TH bgColor=#c0c0c0 borderColor=#000000>skid_number</TH><TH bgColor=#c0c0c0 borderColor=#000000>part_number</TH><TH bgColor=#c0c0c0 borderColor=#000000>Pcs</TH><TH bgColor=#c0c0c0 borderColor=#000000>postal_code</TH><TH bgColor=#c0c0c0 borderColor=#000000>weight</TH><TH bgColor=#c0c0c0 borderColor=#000000>cost</TH><TH bgColor=#c0c0c0 borderColor=#000000>transaction_date</TH></TR></THEAD><TBODY><TR vAlign=top><TD borderColor=#d0d7e5>QJ</TD><TD borderColor=#d0d7e5>20311</TD><TD borderColor=#d0d7e5>544P24143</TD><TD borderColor=#d0d7e5 align=right>1</TD><TD borderColor=#d0d7e5>Y1A2V3</TD><TD borderColor=#d0d7e5 align=right>4.717</TD><TD borderColor=#d0d7e5 align=right>13.68</TD><TD borderColor=#d0d7e5>20100804</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>QJ</TD><TD borderColor=#d0d7e5>20311</TD><TD borderColor=#d0d7e5>544P24143</TD><TD borderColor=#d0d7e5 align=right>1</TD><TD borderColor=#d0d7e5>V6B1Z2</TD><TD borderColor=#d0d7e5 align=right>2.087</TD><TD borderColor=#d0d7e5 align=right>11</TD><TD borderColor=#d0d7e5>20100804</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>QJ</TD><TD borderColor=#d0d7e5>20311</TD><TD borderColor=#d0d7e5>544P24185</TD><TD borderColor=#d0d7e5 align=right>1</TD><TD borderColor=#d0d7e5>T5M1V8</TD><TD borderColor=#d0d7e5 align=right>5.466</TD><TD borderColor=#d0d7e5 align=right>14.18</TD><TD borderColor=#d0d7e5>20100804</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>QJ</TD><TD borderColor=#d0d7e5>20311</TD><TD borderColor=#d0d7e5>544P24143</TD><TD borderColor=#d0d7e5 align=right>1</TD><TD borderColor=#d0d7e5>S4N5B2</TD><TD borderColor=#d0d7e5 align=right>4.559</TD><TD borderColor=#d0d7e5 align=right>11.44</TD><TD borderColor=#d0d7e5>20100804</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>QJ</TD><TD borderColor=#d0d7e5>20311</TD><TD borderColor=#d0d7e5>109R00752</TD><TD borderColor=#d0d7e5 align=right>1</TD><TD borderColor=#d0d7e5>M4W3H1</TD><TD borderColor=#d0d7e5 align=right>1.978</TD><TD borderColor=#d0d7e5 align=right>6.2</TD><TD borderColor=#d0d7e5>20100804</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>QJ</TD><TD borderColor=#d0d7e5>20311</TD><TD borderColor=#d0d7e5>544P24143</TD><TD borderColor=#d0d7e5 align=right>1</TD><TD borderColor=#d0d7e5>L8E4W8</TD><TD borderColor=#d0d7e5 align=right>2.168</TD><TD borderColor=#d0d7e5 align=right>6.6</TD><TD borderColor=#d0d7e5>20100804</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>QJ</TD><TD borderColor=#d0d7e5>20311</TD><TD borderColor=#d0d7e5>544P24143</TD><TD borderColor=#d0d7e5 align=right>1</TD><TD borderColor=#d0d7e5>M4W3H1</TD><TD borderColor=#d0d7e5 align=right>2.05</TD><TD borderColor=#d0d7e5 align=right>6.36</TD><TD borderColor=#d0d7e5>20100804</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>QJ</TD><TD borderColor=#d0d7e5>20311</TD><TD borderColor=#d0d7e5>109R00752</TD><TD borderColor=#d0d7e5 align=right>1</TD><TD borderColor=#d0d7e5>B3B1L2</TD><TD borderColor=#d0d7e5 align=right>2.032</TD><TD borderColor=#d0d7e5 align=right>9.83</TD><TD borderColor=#d0d7e5>20100804</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>QJ</TD><TD borderColor=#d0d7e5>20311</TD><TD borderColor=#d0d7e5>544P24143</TD><TD borderColor=#d0d7e5 align=right>1</TD><TD borderColor=#d0d7e5>V6A2S8</TD><TD borderColor=#d0d7e5 align=right>4.581</TD><TD borderColor=#d0d7e5 align=right>13.68</TD><TD borderColor=#d0d7e5>20100804</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>QJ</TD><TD borderColor=#d0d7e5>20311</TD><TD borderColor=#d0d7e5>544P24143</TD><TD borderColor=#d0d7e5 align=right>1</TD><TD borderColor=#d0d7e5>M4W3H1</TD><TD borderColor=#d0d7e5 align=right>2.132</TD><TD borderColor=#d0d7e5 align=right>6.36</TD><TD borderColor=#d0d7e5>20100804</TD></TR></TBODY><TFOOT></TFOOT></TABLE>
 

tweedle

Well-known Member
Joined
Aug 1, 2010
Messages
1,559
There has to be something else; a third table that ties these two, otherwise anything you do here is guesswork.
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,351
Office Version
  1. 365
Platform
  1. Windows
Got to agree with tweedle.

Is this all the data/tables you have?

At any point has everything been in one table and then split into 2 tables for some reason.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,168,111
Messages
5,857,448
Members
431,880
Latest member
kar2rost

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