filter list with subtitles (keep the subtitles)
I have a excel file with a list like the following. The first 3 columns are always the same (Color, Form, Size), the rest of the columns can be different.
Color Form Size other1 other2
blue 1 2 asdf asdf
red 2 2 asdf asdf
Color Form Size other1 other2 other3
green 1 3 asdf asdf asdf
red 3 2 asdf asdf asdf
Color Form Size stuff1 stuff2 stuff3
blue 2 2 asdf asdf asdf
I would like to filter for the Form, and only show rows with for example Form=1, but keep the subtitles. So with the Filter Form=1 it should look like:
Color Form Size other1 other2
blue 1 2 asdf asdf
Color Form Size other1 other2 other3
green 1 3 asdf asdf asdf
Color Form Size stuff1 stuff2 stuff3
Is it possible to create this with Excel in a userfriendly way?
microsoft-excel
asked Jan 31 at 14:19
nbarnbar
14316
add a comment |
I have a excel file with a list like the following. The first 3 columns are always the same (Color, Form, Size), the rest of the columns can be different.
Color Form Size other1 other2
blue 1 2 asdf asdf
red 2 2 asdf asdf
Color Form Size other1 other2 other3
green 1 3 asdf asdf asdf
red 3 2 asdf asdf asdf
Color Form Size stuff1 stuff2 stuff3
blue 2 2 asdf asdf asdf
I would like to filter for the Form, and only show rows with for example Form=1, but keep the subtitles. So with the Filter Form=1 it should look like:
Color Form Size other1 other2
blue 1 2 asdf asdf
Color Form Size other1 other2 other3
green 1 3 asdf asdf asdf
Color Form Size stuff1 stuff2 stuff3
Is it possible to create this with Excel in a userfriendly way?
microsoft-excel
asked Jan 31 at 14:19
nbarnbar
14316
Assuming entries with the same criteria for Color/Form/Size would all have the same information in other1/other2/other3/stuff1/stuff2/stuff3, wouldn't it be easier to use a table and have all information in one row per entry? So, if blue - 1 - 2 has the same date in each sub-set, move those columns to a single table with 11 columns. Would that work?
– jrichall
Jan 31 at 18:17
add a comment |
I have a excel file with a list like the following. The first 3 columns are always the same (Color, Form, Size), the rest of the columns can be different.
Color Form Size other1 other2
blue 1 2 asdf asdf
red 2 2 asdf asdf
Color Form Size other1 other2 other3
green 1 3 asdf asdf asdf
red 3 2 asdf asdf asdf
Color Form Size stuff1 stuff2 stuff3
blue 2 2 asdf asdf asdf
I would like to filter for the Form, and only show rows with for example Form=1, but keep the subtitles. So with the Filter Form=1 it should look like:
Color Form Size other1 other2
blue 1 2 asdf asdf
Color Form Size other1 other2 other3
green 1 3 asdf asdf asdf
Color Form Size stuff1 stuff2 stuff3
Is it possible to create this with Excel in a userfriendly way?
microsoft-excel
asked Jan 31 at 14:19
nbarnbar
14316
I have a excel file with a list like the following. The first 3 columns are always the same (Color, Form, Size), the rest of the columns can be different.
Color Form Size other1 other2
blue 1 2 asdf asdf
red 2 2 asdf asdf
Color Form Size other1 other2 other3
green 1 3 asdf asdf asdf
red 3 2 asdf asdf asdf
Color Form Size stuff1 stuff2 stuff3
blue 2 2 asdf asdf asdf
I would like to filter for the Form, and only show rows with for example Form=1, but keep the subtitles. So with the Filter Form=1 it should look like:
Color Form Size other1 other2
blue 1 2 asdf asdf
Color Form Size other1 other2 other3
green 1 3 asdf asdf asdf
Color Form Size stuff1 stuff2 stuff3
Is it possible to create this with Excel in a userfriendly way?
microsoft-excel
microsoft-excel
asked Jan 31 at 14:19
nbarnbar
14316
asked Jan 31 at 14:19
nbarnbar
14316
asked Jan 31 at 14:19
nbarnbar
14316
asked Jan 31 at 14:19
nbarnbar
14316
asked Jan 31 at 14:19
nbarnbar
14316
14316
Assuming entries with the same criteria for Color/Form/Size would all have the same information in other1/other2/other3/stuff1/stuff2/stuff3, wouldn't it be easier to use a table and have all information in one row per entry? So, if blue - 1 - 2 has the same date in each sub-set, move those columns to a single table with 11 columns. Would that work?
– jrichall
Jan 31 at 18:17
add a comment |
Assuming entries with the same criteria for Color/Form/Size would all have the same information in other1/other2/other3/stuff1/stuff2/stuff3, wouldn't it be easier to use a table and have all information in one row per entry? So, if blue - 1 - 2 has the same date in each sub-set, move those columns to a single table with 11 columns. Would that work?
– jrichall
Jan 31 at 18:17
Assuming entries with the same criteria for Color/Form/Size would all have the same information in other1/other2/other3/stuff1/stuff2/stuff3, wouldn't it be easier to use a table and have all information in one row per entry? So, if blue - 1 - 2 has the same date in each sub-set, move those columns to a single table with 11 columns. Would that work?
– jrichall
Jan 31 at 18:17
Assuming entries with the same criteria for Color/Form/Size would all have the same information in other1/other2/other3/stuff1/stuff2/stuff3, wouldn't it be easier to use a table and have all information in one row per entry? So, if blue - 1 - 2 has the same date in each sub-set, move those columns to a single table with 11 columns. Would that work?
– jrichall
Jan 31 at 18:17
add a comment |
0
active
oldest
votes
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%2f1400588%2ffilter-list-with-subtitles-keep-the-subtitles%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
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%2f1400588%2ffilter-list-with-subtitles-keep-the-subtitles%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
Assuming entries with the same criteria for Color/Form/Size would all have the same information in other1/other2/other3/stuff1/stuff2/stuff3, wouldn't it be easier to use a table and have all information in one row per entry? So, if blue - 1 - 2 has the same date in each sub-set, move those columns to a single table with 11 columns. Would that work?
– jrichall
Jan 31 at 18:17