Matching Multiple Columns in Excel
I have 60 columns in one table and 60 columns in another table and in the third table it should display matching records as 1 and unmatch records as 0. I am able to do with one column only but multiple columns, facing problem. Note: All the matched and unmatched records should display in the third table all at a time.
microsoft-excel microsoft-excel-2010 microsoft-excel-2007
edited Jan 21 at 12:24
Ahmed Ashour
1,3251715
asked Jan 21 at 7:34
user987777user987777
1
add a comment |
I have 60 columns in one table and 60 columns in another table and in the third table it should display matching records as 1 and unmatch records as 0. I am able to do with one column only but multiple columns, facing problem. Note: All the matched and unmatched records should display in the third table all at a time.
microsoft-excel microsoft-excel-2010 microsoft-excel-2007
edited Jan 21 at 12:24
Ahmed Ashour
1,3251715
asked Jan 21 at 7:34
user987777user987777
1
is your 3rd table showing expected results, or results you are currently getting? What is the formula you are currently using?
– Forward Ed
Jan 21 at 14:04
Why column 1 in the row corresponding to Sweets displaying 0, and apples is displaying 1?
– Forward Ed
Jan 21 at 14:05
add a comment |
I have 60 columns in one table and 60 columns in another table and in the third table it should display matching records as 1 and unmatch records as 0. I am able to do with one column only but multiple columns, facing problem. Note: All the matched and unmatched records should display in the third table all at a time.
microsoft-excel microsoft-excel-2010 microsoft-excel-2007
edited Jan 21 at 12:24
Ahmed Ashour
1,3251715
asked Jan 21 at 7:34
user987777user987777
1
I have 60 columns in one table and 60 columns in another table and in the third table it should display matching records as 1 and unmatch records as 0. I am able to do with one column only but multiple columns, facing problem. Note: All the matched and unmatched records should display in the third table all at a time.
microsoft-excel microsoft-excel-2010 microsoft-excel-2007
microsoft-excel microsoft-excel-2010 microsoft-excel-2007
edited Jan 21 at 12:24
Ahmed Ashour
1,3251715
asked Jan 21 at 7:34
user987777user987777
1
edited Jan 21 at 12:24
Ahmed Ashour
1,3251715
asked Jan 21 at 7:34
user987777user987777
1
edited Jan 21 at 12:24
Ahmed Ashour
1,3251715
edited Jan 21 at 12:24
Ahmed Ashour
1,3251715
edited Jan 21 at 12:24
Ahmed Ashour
1,3251715
1,3251715
asked Jan 21 at 7:34
user987777user987777
1
asked Jan 21 at 7:34
user987777user987777
1
asked Jan 21 at 7:34
user987777user987777
1
1
is your 3rd table showing expected results, or results you are currently getting? What is the formula you are currently using?
– Forward Ed
Jan 21 at 14:04
Why column 1 in the row corresponding to Sweets displaying 0, and apples is displaying 1?
– Forward Ed
Jan 21 at 14:05
add a comment |
is your 3rd table showing expected results, or results you are currently getting? What is the formula you are currently using?
– Forward Ed
Jan 21 at 14:04
Why column 1 in the row corresponding to Sweets displaying 0, and apples is displaying 1?
– Forward Ed
Jan 21 at 14:05
is your 3rd table showing expected results, or results you are currently getting? What is the formula you are currently using?
– Forward Ed
Jan 21 at 14:04
is your 3rd table showing expected results, or results you are currently getting? What is the formula you are currently using?
– Forward Ed
Jan 21 at 14:04
Why column 1 in the row corresponding to Sweets displaying 0, and apples is displaying 1?
– Forward Ed
Jan 21 at 14:05
Why column 1 in the row corresponding to Sweets displaying 0, and apples is displaying 1?
– Forward Ed
Jan 21 at 14:05
add a comment |
1 Answer
1
active
oldest
votes
It should simply be a matter of pointing at one cell and and saying equal to another cell then the copy the formula down and right as far as needed. If you select the cells with the mouse after starting to enter the formula in the cell, excel should add in the worksheet name for you. This will give you TRUE/FALSE results. In order to change them to 1 or 0 simply put the true or false result through a math operation that will not change the value. --, *1, +0, /1 all work. The following is a formula you could use:
=--(A3=E3)
Remember to edit your cell reference to suit your data:
answered Jan 21 at 14:14
Forward EdForward Ed
817214
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%2f1396503%2fmatching-multiple-columns-in-excel%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
It should simply be a matter of pointing at one cell and and saying equal to another cell then the copy the formula down and right as far as needed. If you select the cells with the mouse after starting to enter the formula in the cell, excel should add in the worksheet name for you. This will give you TRUE/FALSE results. In order to change them to 1 or 0 simply put the true or false result through a math operation that will not change the value. --, *1, +0, /1 all work. The following is a formula you could use:
=--(A3=E3)
Remember to edit your cell reference to suit your data:
answered Jan 21 at 14:14
Forward EdForward Ed
817214
add a comment |
It should simply be a matter of pointing at one cell and and saying equal to another cell then the copy the formula down and right as far as needed. If you select the cells with the mouse after starting to enter the formula in the cell, excel should add in the worksheet name for you. This will give you TRUE/FALSE results. In order to change them to 1 or 0 simply put the true or false result through a math operation that will not change the value. --, *1, +0, /1 all work. The following is a formula you could use:
=--(A3=E3)
Remember to edit your cell reference to suit your data:
answered Jan 21 at 14:14
Forward EdForward Ed
817214
add a comment |
It should simply be a matter of pointing at one cell and and saying equal to another cell then the copy the formula down and right as far as needed. If you select the cells with the mouse after starting to enter the formula in the cell, excel should add in the worksheet name for you. This will give you TRUE/FALSE results. In order to change them to 1 or 0 simply put the true or false result through a math operation that will not change the value. --, *1, +0, /1 all work. The following is a formula you could use:
=--(A3=E3)
Remember to edit your cell reference to suit your data:
answered Jan 21 at 14:14
Forward EdForward Ed
817214
It should simply be a matter of pointing at one cell and and saying equal to another cell then the copy the formula down and right as far as needed. If you select the cells with the mouse after starting to enter the formula in the cell, excel should add in the worksheet name for you. This will give you TRUE/FALSE results. In order to change them to 1 or 0 simply put the true or false result through a math operation that will not change the value. --, *1, +0, /1 all work. The following is a formula you could use:
=--(A3=E3)
Remember to edit your cell reference to suit your data:
answered Jan 21 at 14:14
Forward EdForward Ed
817214
answered Jan 21 at 14:14
Forward EdForward Ed
817214
answered Jan 21 at 14:14
Forward EdForward Ed
817214
answered Jan 21 at 14:14
Forward EdForward Ed
817214
817214
add a comment |
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%2f1396503%2fmatching-multiple-columns-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
is your 3rd table showing expected results, or results you are currently getting? What is the formula you are currently using?
– Forward Ed
Jan 21 at 14:04
Why column 1 in the row corresponding to Sweets displaying 0, and apples is displaying 1?
– Forward Ed
Jan 21 at 14:05