How to order two columns from different data tables to match their rows in excel?
I have 2 datasets, where I know the data is matching from using COUNTIF, and I've put them in the same sheet in excel. I am now trying to match together rows that correspond to each other. So for example like having this:
Name Age Name Age
Tom 22 Sam 70
Ben 56 Tom 22
Bob 37 Ben 56
Sam 70 Dan 61
Dan 61 Bob 37
And I want to order these so I have this:
Name Age Name Age
Tom 22 Tom 22
Ben 56 Ben 56
Sam 70 Sam 70
Bob 37 Bob 37
Dan 61 Dan 61
I am new to using excel and so any guidance on where to start to be able to do this would be appreciated.
microsoft-excel worksheet-function
asked Jan 24 at 10:26
DN1DN1
11
add a comment |
I have 2 datasets, where I know the data is matching from using COUNTIF, and I've put them in the same sheet in excel. I am now trying to match together rows that correspond to each other. So for example like having this:
Name Age Name Age
Tom 22 Sam 70
Ben 56 Tom 22
Bob 37 Ben 56
Sam 70 Dan 61
Dan 61 Bob 37
And I want to order these so I have this:
Name Age Name Age
Tom 22 Tom 22
Ben 56 Ben 56
Sam 70 Sam 70
Bob 37 Bob 37
Dan 61 Dan 61
I am new to using excel and so any guidance on where to start to be able to do this would be appreciated.
microsoft-excel worksheet-function
asked Jan 24 at 10:26
DN1DN1
11
add a comment |
I have 2 datasets, where I know the data is matching from using COUNTIF, and I've put them in the same sheet in excel. I am now trying to match together rows that correspond to each other. So for example like having this:
Name Age Name Age
Tom 22 Sam 70
Ben 56 Tom 22
Bob 37 Ben 56
Sam 70 Dan 61
Dan 61 Bob 37
And I want to order these so I have this:
Name Age Name Age
Tom 22 Tom 22
Ben 56 Ben 56
Sam 70 Sam 70
Bob 37 Bob 37
Dan 61 Dan 61
I am new to using excel and so any guidance on where to start to be able to do this would be appreciated.
microsoft-excel worksheet-function
asked Jan 24 at 10:26
DN1DN1
11
I have 2 datasets, where I know the data is matching from using COUNTIF, and I've put them in the same sheet in excel. I am now trying to match together rows that correspond to each other. So for example like having this:
Name Age Name Age
Tom 22 Sam 70
Ben 56 Tom 22
Bob 37 Ben 56
Sam 70 Dan 61
Dan 61 Bob 37
And I want to order these so I have this:
Name Age Name Age
Tom 22 Tom 22
Ben 56 Ben 56
Sam 70 Sam 70
Bob 37 Bob 37
Dan 61 Dan 61
I am new to using excel and so any guidance on where to start to be able to do this would be appreciated.
microsoft-excel worksheet-function
microsoft-excel worksheet-function
asked Jan 24 at 10:26
DN1DN1
11
asked Jan 24 at 10:26
DN1DN1
11
asked Jan 24 at 10:26
DN1DN1
11
asked Jan 24 at 10:26
DN1DN1
11
asked Jan 24 at 10:26
DN1DN1
11
11
add a comment |
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%2f1397861%2fhow-to-order-two-columns-from-different-data-tables-to-match-their-rows-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%2f1397861%2fhow-to-order-two-columns-from-different-data-tables-to-match-their-rows-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
