How to sort data in excel?
I have two columns:
- the first column has all the names of the furniture that we normally have in a house (like bed, chair, lamp, etc)
- the second column has a list of different types of houses (house 1, house 2, house 3, etc).
The problem is there are about 124 elements in the furniture column and about 25 elements in the house column, and some of the elements from the first column are present in more than one house.
What I would like to do is to see which furniture is present in more than one house? The best solution would be if I click on a particular house type, I would be able to see all the furniture it has.
Can someone put me in the right direction as to what I should look for? I tried using the formula for duplicate formula in Excel but somehow doesn't seem to work.
microsoft-excel worksheet-function microsoft-excel-2016
edited Feb 14 at 15:35
bertieb
5,672112542
asked Feb 14 at 14:31
DavidDavid
1
add a comment |
I have two columns:
- the first column has all the names of the furniture that we normally have in a house (like bed, chair, lamp, etc)
- the second column has a list of different types of houses (house 1, house 2, house 3, etc).
The problem is there are about 124 elements in the furniture column and about 25 elements in the house column, and some of the elements from the first column are present in more than one house.
What I would like to do is to see which furniture is present in more than one house? The best solution would be if I click on a particular house type, I would be able to see all the furniture it has.
Can someone put me in the right direction as to what I should look for? I tried using the formula for duplicate formula in Excel but somehow doesn't seem to work.
microsoft-excel worksheet-function microsoft-excel-2016
edited Feb 14 at 15:35
bertieb
5,672112542
asked Feb 14 at 14:31
DavidDavid
1
Can you please edit your question to show us what you've tried so far and explain how it fails to achieve the desired result?
– cybernetic.nomad
Feb 14 at 15:28
(A) How to sort data in excel? (B) What I would like to do is to see which furniture is present in more than one house? (C) The best solution would be if I click on a particular house type, I would be able to see all the furniture it has. … … … … … … … … … … … … … … These are three different questions. Please edit your question to make it clearer and more complete.
– Scott
Feb 14 at 20:59
It would help if you add a screenshot or mock-up of your data so we can understand what it actually looks like. But you can turn on filtering, which would allow you to select a house type and hide all records for other types. You can also select all of the data and select sorting. Then sort on the second column. From the question, it's hard to know what would be the best solution, or what you've tried and had a problem with.
– fixer1234
Feb 15 at 5:09
1
What you’re describing is exactly a what PivotTable does. A PivotTable will “sort” (really gather and summarize) your data and let you explore it on the fly.
– whiskeychief
Feb 15 at 10:51
add a comment |
I have two columns:
- the first column has all the names of the furniture that we normally have in a house (like bed, chair, lamp, etc)
- the second column has a list of different types of houses (house 1, house 2, house 3, etc).
The problem is there are about 124 elements in the furniture column and about 25 elements in the house column, and some of the elements from the first column are present in more than one house.
What I would like to do is to see which furniture is present in more than one house? The best solution would be if I click on a particular house type, I would be able to see all the furniture it has.
Can someone put me in the right direction as to what I should look for? I tried using the formula for duplicate formula in Excel but somehow doesn't seem to work.
microsoft-excel worksheet-function microsoft-excel-2016
edited Feb 14 at 15:35
bertieb
5,672112542
asked Feb 14 at 14:31
DavidDavid
1
I have two columns:
- the first column has all the names of the furniture that we normally have in a house (like bed, chair, lamp, etc)
- the second column has a list of different types of houses (house 1, house 2, house 3, etc).
The problem is there are about 124 elements in the furniture column and about 25 elements in the house column, and some of the elements from the first column are present in more than one house.
What I would like to do is to see which furniture is present in more than one house? The best solution would be if I click on a particular house type, I would be able to see all the furniture it has.
Can someone put me in the right direction as to what I should look for? I tried using the formula for duplicate formula in Excel but somehow doesn't seem to work.
microsoft-excel worksheet-function microsoft-excel-2016
microsoft-excel worksheet-function microsoft-excel-2016
edited Feb 14 at 15:35
bertieb
5,672112542
asked Feb 14 at 14:31
DavidDavid
1
edited Feb 14 at 15:35
bertieb
5,672112542
asked Feb 14 at 14:31
DavidDavid
1
edited Feb 14 at 15:35
bertieb
5,672112542
edited Feb 14 at 15:35
bertieb
5,672112542
edited Feb 14 at 15:35
bertieb
5,672112542
5,672112542
asked Feb 14 at 14:31
DavidDavid
1
asked Feb 14 at 14:31
DavidDavid
1
asked Feb 14 at 14:31
DavidDavid
1
1
Can you please edit your question to show us what you've tried so far and explain how it fails to achieve the desired result?
– cybernetic.nomad
Feb 14 at 15:28
(A) How to sort data in excel? (B) What I would like to do is to see which furniture is present in more than one house? (C) The best solution would be if I click on a particular house type, I would be able to see all the furniture it has. … … … … … … … … … … … … … … These are three different questions. Please edit your question to make it clearer and more complete.
– Scott
Feb 14 at 20:59
It would help if you add a screenshot or mock-up of your data so we can understand what it actually looks like. But you can turn on filtering, which would allow you to select a house type and hide all records for other types. You can also select all of the data and select sorting. Then sort on the second column. From the question, it's hard to know what would be the best solution, or what you've tried and had a problem with.
– fixer1234
Feb 15 at 5:09
1
What you’re describing is exactly a what PivotTable does. A PivotTable will “sort” (really gather and summarize) your data and let you explore it on the fly.
– whiskeychief
Feb 15 at 10:51
add a comment |
Can you please edit your question to show us what you've tried so far and explain how it fails to achieve the desired result?
– cybernetic.nomad
Feb 14 at 15:28
(A) How to sort data in excel? (B) What I would like to do is to see which furniture is present in more than one house? (C) The best solution would be if I click on a particular house type, I would be able to see all the furniture it has. … … … … … … … … … … … … … … These are three different questions. Please edit your question to make it clearer and more complete.
– Scott
Feb 14 at 20:59
It would help if you add a screenshot or mock-up of your data so we can understand what it actually looks like. But you can turn on filtering, which would allow you to select a house type and hide all records for other types. You can also select all of the data and select sorting. Then sort on the second column. From the question, it's hard to know what would be the best solution, or what you've tried and had a problem with.
– fixer1234
Feb 15 at 5:09
1
What you’re describing is exactly a what PivotTable does. A PivotTable will “sort” (really gather and summarize) your data and let you explore it on the fly.
– whiskeychief
Feb 15 at 10:51
Can you please edit your question to show us what you've tried so far and explain how it fails to achieve the desired result?
– cybernetic.nomad
Feb 14 at 15:28
Can you please edit your question to show us what you've tried so far and explain how it fails to achieve the desired result?
– cybernetic.nomad
Feb 14 at 15:28
(A) How to sort data in excel? (B) What I would like to do is to see which furniture is present in more than one house? (C) The best solution would be if I click on a particular house type, I would be able to see all the furniture it has. … … … … … … … … … … … … … … These are three different questions. Please edit your question to make it clearer and more complete.
– Scott
Feb 14 at 20:59
(A) How to sort data in excel? (B) What I would like to do is to see which furniture is present in more than one house? (C) The best solution would be if I click on a particular house type, I would be able to see all the furniture it has. … … … … … … … … … … … … … … These are three different questions. Please edit your question to make it clearer and more complete.
– Scott
Feb 14 at 20:59
It would help if you add a screenshot or mock-up of your data so we can understand what it actually looks like. But you can turn on filtering, which would allow you to select a house type and hide all records for other types. You can also select all of the data and select sorting. Then sort on the second column. From the question, it's hard to know what would be the best solution, or what you've tried and had a problem with.
– fixer1234
Feb 15 at 5:09
It would help if you add a screenshot or mock-up of your data so we can understand what it actually looks like. But you can turn on filtering, which would allow you to select a house type and hide all records for other types. You can also select all of the data and select sorting. Then sort on the second column. From the question, it's hard to know what would be the best solution, or what you've tried and had a problem with.
– fixer1234
Feb 15 at 5:09
1
1
What you’re describing is exactly a what PivotTable does. A PivotTable will “sort” (really gather and summarize) your data and let you explore it on the fly.
– whiskeychief
Feb 15 at 10:51
What you’re describing is exactly a what PivotTable does. A PivotTable will “sort” (really gather and summarize) your data and let you explore it on the fly.
– whiskeychief
Feb 15 at 10:51
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%2f1405716%2fhow-to-sort-data-in-excel%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%2f1405716%2fhow-to-sort-data-in-excel%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
Can you please edit your question to show us what you've tried so far and explain how it fails to achieve the desired result?
– cybernetic.nomad
Feb 14 at 15:28
(A) How to sort data in excel? (B) What I would like to do is to see which furniture is present in more than one house? (C) The best solution would be if I click on a particular house type, I would be able to see all the furniture it has. … … … … … … … … … … … … … … These are three different questions. Please edit your question to make it clearer and more complete.
– Scott
Feb 14 at 20:59
It would help if you add a screenshot or mock-up of your data so we can understand what it actually looks like. But you can turn on filtering, which would allow you to select a house type and hide all records for other types. You can also select all of the data and select sorting. Then sort on the second column. From the question, it's hard to know what would be the best solution, or what you've tried and had a problem with.
– fixer1234
Feb 15 at 5:09
1
What you’re describing is exactly a what PivotTable does. A PivotTable will “sort” (really gather and summarize) your data and let you explore it on the fly.
– whiskeychief
Feb 15 at 10:51