Excel - show relations between two columns
-1
my excel contains three columns
customer_id category_a category b
1 3 3
1 3 3
2 2 3
3 2 3
4 1 1
What I need to do is display how many customers were in category_a, how many customers is currently in category b and who comes from category_a to category_b.
Each customer must be counted only once.
Something like on screen bellow https://i.redd.it/0yd4yx222bl01.png
microsoft-excel
asked Jan 13 at 13:19
Jack_CarverJack_Carver
11
add a comment |
-1
my excel contains three columns
customer_id category_a category b
1 3 3
1 3 3
2 2 3
3 2 3
4 1 1
What I need to do is display how many customers were in category_a, how many customers is currently in category b and who comes from category_a to category_b.
Each customer must be counted only once.
Something like on screen bellow https://i.redd.it/0yd4yx222bl01.png
microsoft-excel
asked Jan 13 at 13:19
Jack_CarverJack_Carver
11
2
How do you identify if a customer "comes from category_a to category_b"? What do the numbers in the category columns mean? Mock up the expected result based on your sample data and explain the logic that leads to that result. As a new user here, read the following carefully: Edit your question to add the detail I asked for. Do not provide that in a comment. Post a comment when you have edited your question to alert the people who are following the question.
– teylyn
Jan 13 at 21:19
To add to teylyn's questions: Is each row a record, or is each column independent? These are just lists of numbers, with no explanation or logic. The question is not answerable as-is.
– fixer1234
Jan 13 at 23:51
add a comment |
-1
-1
-1
my excel contains three columns
customer_id category_a category b
1 3 3
1 3 3
2 2 3
3 2 3
4 1 1
What I need to do is display how many customers were in category_a, how many customers is currently in category b and who comes from category_a to category_b.
Each customer must be counted only once.
Something like on screen bellow https://i.redd.it/0yd4yx222bl01.png
microsoft-excel
asked Jan 13 at 13:19
Jack_CarverJack_Carver
11
my excel contains three columns
customer_id category_a category b
1 3 3
1 3 3
2 2 3
3 2 3
4 1 1
What I need to do is display how many customers were in category_a, how many customers is currently in category b and who comes from category_a to category_b.
Each customer must be counted only once.
Something like on screen bellow https://i.redd.it/0yd4yx222bl01.png
microsoft-excel
microsoft-excel
asked Jan 13 at 13:19
Jack_CarverJack_Carver
11
asked Jan 13 at 13:19
Jack_CarverJack_Carver
11
asked Jan 13 at 13:19
Jack_CarverJack_Carver
11
asked Jan 13 at 13:19
Jack_CarverJack_Carver
11
asked Jan 13 at 13:19
Jack_CarverJack_Carver
11
11
2
How do you identify if a customer "comes from category_a to category_b"? What do the numbers in the category columns mean? Mock up the expected result based on your sample data and explain the logic that leads to that result. As a new user here, read the following carefully: Edit your question to add the detail I asked for. Do not provide that in a comment. Post a comment when you have edited your question to alert the people who are following the question.
– teylyn
Jan 13 at 21:19
To add to teylyn's questions: Is each row a record, or is each column independent? These are just lists of numbers, with no explanation or logic. The question is not answerable as-is.
– fixer1234
Jan 13 at 23:51
add a comment |
2
How do you identify if a customer "comes from category_a to category_b"? What do the numbers in the category columns mean? Mock up the expected result based on your sample data and explain the logic that leads to that result. As a new user here, read the following carefully: Edit your question to add the detail I asked for. Do not provide that in a comment. Post a comment when you have edited your question to alert the people who are following the question.
– teylyn
Jan 13 at 21:19
To add to teylyn's questions: Is each row a record, or is each column independent? These are just lists of numbers, with no explanation or logic. The question is not answerable as-is.
– fixer1234
Jan 13 at 23:51
2
2
How do you identify if a customer "comes from category_a to category_b"? What do the numbers in the category columns mean? Mock up the expected result based on your sample data and explain the logic that leads to that result. As a new user here, read the following carefully: Edit your question to add the detail I asked for. Do not provide that in a comment. Post a comment when you have edited your question to alert the people who are following the question.
– teylyn
Jan 13 at 21:19
How do you identify if a customer "comes from category_a to category_b"? What do the numbers in the category columns mean? Mock up the expected result based on your sample data and explain the logic that leads to that result. As a new user here, read the following carefully: Edit your question to add the detail I asked for. Do not provide that in a comment. Post a comment when you have edited your question to alert the people who are following the question.
– teylyn
Jan 13 at 21:19
To add to teylyn's questions: Is each row a record, or is each column independent? These are just lists of numbers, with no explanation or logic. The question is not answerable as-is.
– fixer1234
Jan 13 at 23:51
To add to teylyn's questions: Is each row a record, or is each column independent? These are just lists of numbers, with no explanation or logic. The question is not answerable as-is.
– fixer1234
Jan 13 at 23: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
});
}
});
draft saved
draft discarded
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%2f1393766%2fexcel-show-relations-between-two-columns%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
draft saved
draft discarded
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.
draft saved
draft discarded
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%2f1393766%2fexcel-show-relations-between-two-columns%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
2
How do you identify if a customer "comes from category_a to category_b"? What do the numbers in the category columns mean? Mock up the expected result based on your sample data and explain the logic that leads to that result. As a new user here, read the following carefully: Edit your question to add the detail I asked for. Do not provide that in a comment. Post a comment when you have edited your question to alert the people who are following the question.
– teylyn
Jan 13 at 21:19
To add to teylyn's questions: Is each row a record, or is each column independent? These are just lists of numbers, with no explanation or logic. The question is not answerable as-is.
– fixer1234
Jan 13 at 23:51