Excel Automatically GroupingAutomatically keeping two excel data tables in-sync (w/out VBA)What can cause an...
Plausible reason for gold-digging ant
False written accusations not made public - is there law to cover this?
Separate environment for personal and development use under macOS
Do "fields" always combine by addition?
How do you voice extended chords?
Does diversity provide anything that meritocracy does not?
How do I append a character to the end of every line in an excel cell?
What is a good reason for every spaceship to carry a weapon on board?
What will happen if Parliament votes "no" on each of the Brexit-related votes to be held on the 12th, 13th and 14th of March?
What happens when I Twin Life Transference?
What makes papers publishable in top-tier journals?
Is there a defined priority for pattern matching?
How to visualize the Riemann-Roch theorem from complex analysis or geometric topology considerations?
Why is Agricola named as such?
Why are all my replica super soldiers young adults or old teenagers?
Why is it that Bernie Sanders is always called a "socialist"?
Why did Democrats in the Senate oppose the Born-Alive Abortion Survivors Protection Act (2019 S.130)?
What game did these black and yellow dice come from?
Am I a Rude Number?
How do I prevent a homebrew Grappling Hook feature from trivializing Tomb of Annihilation?
Cat is tipping over bed-side lamps during the night
Globe trotting Grandpa. Where is he going next?
TikZ graph edges not drawn nicely
Is the child responsible for the Parent PLUS Loan when the parent has passed away?
Excel Automatically Grouping
Automatically keeping two excel data tables in-sync (w/out VBA)What can cause an Excel status bar quick sum calculation to be wrong?Advanced cell selection in Excelmerge two rows in excel worksheet where one cell has same content but other cells have different contentHow to select all ActiveX objects in an area using a mouse in Excel?How can I sort Excel cells in groups?How to extend excel formula when adding a new columnHow to add from pivot tableOffice 365 - Excel Advanced Filter - Mass Multiple Entriesexcel How to sum total working hours with positive and negative time
I was referred here from stackoverflow as I was told my question did not require VBA or formulas.
I have a large data set that is in this form, however it is several thousand parts long.
(Note corporate QTY's are not always the sum of all the stores, as sometimes there is some corporate stock separately).
As of now they are all in that form, with the corporate row at the top of every group. I would like to do the equivalent of
- Selecting all the rows between two corporate entries
- Grouping them
The result would be:
However is there a way to do this automatically so I don't have to select the rows in a group manually and hit the group button several thousand times?
microsoft-excel
edited Sep 8 '16 at 13:55
Máté Juhász
14.5k63352
asked Sep 8 '16 at 13:21
ajamessajamess
43
bumped to the homepage by Community♦ 9 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
I was referred here from stackoverflow as I was told my question did not require VBA or formulas.
I have a large data set that is in this form, however it is several thousand parts long.
(Note corporate QTY's are not always the sum of all the stores, as sometimes there is some corporate stock separately).
As of now they are all in that form, with the corporate row at the top of every group. I would like to do the equivalent of
- Selecting all the rows between two corporate entries
- Grouping them
The result would be:
However is there a way to do this automatically so I don't have to select the rows in a group manually and hit the group button several thousand times?
microsoft-excel
edited Sep 8 '16 at 13:55
Máté Juhász
14.5k63352
asked Sep 8 '16 at 13:21
ajamessajamess
43
bumped to the homepage by Community♦ 9 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
I was referred here from stackoverflow as I was told my question did not require VBA or formulas.
I have a large data set that is in this form, however it is several thousand parts long.
(Note corporate QTY's are not always the sum of all the stores, as sometimes there is some corporate stock separately).
As of now they are all in that form, with the corporate row at the top of every group. I would like to do the equivalent of
- Selecting all the rows between two corporate entries
- Grouping them
The result would be:
However is there a way to do this automatically so I don't have to select the rows in a group manually and hit the group button several thousand times?
microsoft-excel
edited Sep 8 '16 at 13:55
Máté Juhász
14.5k63352
asked Sep 8 '16 at 13:21
ajamessajamess
43
I was referred here from stackoverflow as I was told my question did not require VBA or formulas.
I have a large data set that is in this form, however it is several thousand parts long.
(Note corporate QTY's are not always the sum of all the stores, as sometimes there is some corporate stock separately).
As of now they are all in that form, with the corporate row at the top of every group. I would like to do the equivalent of
- Selecting all the rows between two corporate entries
- Grouping them
The result would be:
However is there a way to do this automatically so I don't have to select the rows in a group manually and hit the group button several thousand times?
microsoft-excel
microsoft-excel
edited Sep 8 '16 at 13:55
Máté Juhász
14.5k63352
asked Sep 8 '16 at 13:21
ajamessajamess
43
edited Sep 8 '16 at 13:55
Máté Juhász
14.5k63352
asked Sep 8 '16 at 13:21
ajamessajamess
43
edited Sep 8 '16 at 13:55
Máté Juhász
14.5k63352
edited Sep 8 '16 at 13:55
Máté Juhász
14.5k63352
edited Sep 8 '16 at 13:55
Máté Juhász
14.5k63352
14.5k63352
asked Sep 8 '16 at 13:21
ajamessajamess
43
asked Sep 8 '16 at 13:21
ajamessajamess
43
asked Sep 8 '16 at 13:21
ajamessajamess
43
43
bumped to the homepage by Community♦ 9 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
bumped to the homepage by Community♦ 9 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
If you use the 'Subtotal' button under the Data menu, it will create subgroups for each of the part numbers and calculate a sum (subtotal), count, etc. for each group. You can delete the text below each subgroup if you don't want it in there.
answered Sep 8 '16 at 15:22
ode2kode2k
28225
I would like the grouping to be at the corporate level. The corporate data is the highest level or total, however as mentioned in the question, sometimes there is additional corporate stock not included in the stores below it. So I already have the "summary" lines (the corporate ones), and I want to group all the ones below it.
– ajamess
Sep 8 '16 at 16:10
add a comment |
Can you explain what you are trying to accomplish with the grouping? Are you trying to extract the maximum item quantity's for each store? Normally you could do grouping in pivot tables, or create you own, but I'm just trying to understand what you want to accomplish with this.
This is your initial data, but you would first need to ungroup the grouping by part, and then select how you would want to group.
pivot
answered Sep 9 '16 at 19:30
petergenslerpetergensler
11
Seconding the use of a Pivot Table. This is a no-brainer.
– JaredT
Sep 9 '16 at 19:34
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1122290%2fexcel-automatically-grouping%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
If you use the 'Subtotal' button under the Data menu, it will create subgroups for each of the part numbers and calculate a sum (subtotal), count, etc. for each group. You can delete the text below each subgroup if you don't want it in there.
answered Sep 8 '16 at 15:22
ode2kode2k
28225
I would like the grouping to be at the corporate level. The corporate data is the highest level or total, however as mentioned in the question, sometimes there is additional corporate stock not included in the stores below it. So I already have the "summary" lines (the corporate ones), and I want to group all the ones below it.
– ajamess
Sep 8 '16 at 16:10
add a comment |
If you use the 'Subtotal' button under the Data menu, it will create subgroups for each of the part numbers and calculate a sum (subtotal), count, etc. for each group. You can delete the text below each subgroup if you don't want it in there.
answered Sep 8 '16 at 15:22
ode2kode2k
28225
I would like the grouping to be at the corporate level. The corporate data is the highest level or total, however as mentioned in the question, sometimes there is additional corporate stock not included in the stores below it. So I already have the "summary" lines (the corporate ones), and I want to group all the ones below it.
– ajamess
Sep 8 '16 at 16:10
add a comment |
If you use the 'Subtotal' button under the Data menu, it will create subgroups for each of the part numbers and calculate a sum (subtotal), count, etc. for each group. You can delete the text below each subgroup if you don't want it in there.
answered Sep 8 '16 at 15:22
ode2kode2k
28225
If you use the 'Subtotal' button under the Data menu, it will create subgroups for each of the part numbers and calculate a sum (subtotal), count, etc. for each group. You can delete the text below each subgroup if you don't want it in there.
answered Sep 8 '16 at 15:22
ode2kode2k
28225
answered Sep 8 '16 at 15:22
ode2kode2k
28225
answered Sep 8 '16 at 15:22
ode2kode2k
28225
answered Sep 8 '16 at 15:22
ode2kode2k
28225
28225
I would like the grouping to be at the corporate level. The corporate data is the highest level or total, however as mentioned in the question, sometimes there is additional corporate stock not included in the stores below it. So I already have the "summary" lines (the corporate ones), and I want to group all the ones below it.
– ajamess
Sep 8 '16 at 16:10
add a comment |
I would like the grouping to be at the corporate level. The corporate data is the highest level or total, however as mentioned in the question, sometimes there is additional corporate stock not included in the stores below it. So I already have the "summary" lines (the corporate ones), and I want to group all the ones below it.
– ajamess
Sep 8 '16 at 16:10
I would like the grouping to be at the corporate level. The corporate data is the highest level or total, however as mentioned in the question, sometimes there is additional corporate stock not included in the stores below it. So I already have the "summary" lines (the corporate ones), and I want to group all the ones below it.
– ajamess
Sep 8 '16 at 16:10
I would like the grouping to be at the corporate level. The corporate data is the highest level or total, however as mentioned in the question, sometimes there is additional corporate stock not included in the stores below it. So I already have the "summary" lines (the corporate ones), and I want to group all the ones below it.
– ajamess
Sep 8 '16 at 16:10
add a comment |
Can you explain what you are trying to accomplish with the grouping? Are you trying to extract the maximum item quantity's for each store? Normally you could do grouping in pivot tables, or create you own, but I'm just trying to understand what you want to accomplish with this.
This is your initial data, but you would first need to ungroup the grouping by part, and then select how you would want to group.
pivot
answered Sep 9 '16 at 19:30
petergenslerpetergensler
11
Seconding the use of a Pivot Table. This is a no-brainer.
– JaredT
Sep 9 '16 at 19:34
add a comment |
Can you explain what you are trying to accomplish with the grouping? Are you trying to extract the maximum item quantity's for each store? Normally you could do grouping in pivot tables, or create you own, but I'm just trying to understand what you want to accomplish with this.
This is your initial data, but you would first need to ungroup the grouping by part, and then select how you would want to group.
pivot
answered Sep 9 '16 at 19:30
petergenslerpetergensler
11
Seconding the use of a Pivot Table. This is a no-brainer.
– JaredT
Sep 9 '16 at 19:34
add a comment |
Can you explain what you are trying to accomplish with the grouping? Are you trying to extract the maximum item quantity's for each store? Normally you could do grouping in pivot tables, or create you own, but I'm just trying to understand what you want to accomplish with this.
This is your initial data, but you would first need to ungroup the grouping by part, and then select how you would want to group.
pivot
answered Sep 9 '16 at 19:30
petergenslerpetergensler
11
Can you explain what you are trying to accomplish with the grouping? Are you trying to extract the maximum item quantity's for each store? Normally you could do grouping in pivot tables, or create you own, but I'm just trying to understand what you want to accomplish with this.
This is your initial data, but you would first need to ungroup the grouping by part, and then select how you would want to group.
pivot
answered Sep 9 '16 at 19:30
petergenslerpetergensler
11
edited Sep 9 '16 at 19:38
answered Sep 9 '16 at 19:30
petergenslerpetergensler
11
answered Sep 9 '16 at 19:30
petergenslerpetergensler
11
answered Sep 9 '16 at 19:30
petergenslerpetergensler
11
11
Seconding the use of a Pivot Table. This is a no-brainer.
– JaredT
Sep 9 '16 at 19:34
add a comment |
Seconding the use of a Pivot Table. This is a no-brainer.
– JaredT
Sep 9 '16 at 19:34
Seconding the use of a Pivot Table. This is a no-brainer.
– JaredT
Sep 9 '16 at 19:34
Seconding the use of a Pivot Table. This is a no-brainer.
– JaredT
Sep 9 '16 at 19:34
add a comment |
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1122290%2fexcel-automatically-grouping%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
