Concatenate values from qualifying cellsExcel concatenate strings from cells listed in third cellDisplay a...
my venezuela girlfriend wants to travel the USA where i live.what does she need to do and how expensive will it become or how difficult?
If a warlock makes a Dancing Sword their pact weapon, is there a way to prevent it from disappearing if it's farther away for more than a minute?
What is an equivalently powerful replacement spell for the Yuan-Ti's Suggestion spell?
Rotate ASCII Art by 45 Degrees
My ex-girlfriend uses my Apple ID to log in to her iPad. Do I have to give her my Apple ID password to reset it?
OP Amp not amplifying audio signal
How obscure is the use of 令 in 令和?
Knowledge-based authentication using Domain-driven Design in C#
How to stretch the corners of this image so that it looks like a perfect rectangle?
How to Prove P(a) → ∀x(P(x) ∨ ¬(x = a)) using Natural Deduction
Finitely generated matrix groups whose eigenvalues are all algebraic
Avoiding the "not like other girls" trope?
Why is the sentence "Das ist eine Nase" correct?
how do we prove that a sum of two periods is still a period?
Are British MPs missing the point, with these 'Indicative Votes'?
files created then deleted at every second in tmp directory
Should I tell management that I intend to leave due to bad software development practices?
What does the same-ish mean?
How do I exit BASH while loop using modulus operator?
What reasons are there for a Capitalist to oppose a 100% inheritance tax?
Sums of two squares in arithmetic progressions
Was the Stack Exchange "Happy April Fools" page fitting with the '90's code?
In the UK, is it possible to get a referendum by a court decision?
Does Dispel Magic work on Tiny Hut?
Concatenate values from qualifying cells
Excel concatenate strings from cells listed in third cellDisplay a value next to a cell containing a maximum value in a range.. Excel 2007In Excel 2010, how can I convert cells containing “1 day”, “2 days” etc to just “1”, “2” etcDeleting last characters from a cell in Microsoft Excel 2010?Lookup Values Based on Values in Other CellsFormula-based conditional formatting to format cells in the same rowExcel: Dynamically extract comma separated values and return an added value from a separate listParse a cell and return associated values into another cellCount number of unique comma separated values in an entire columnAllow a cell containing multiple delimited lookup source values to also contain non-lookup values
I have data consisting of day numbers, each with an associated 0/1 value. In the example below, A2:A32 has day number (like 1 in A2, 2 in A3 and so on through A31), B2:B32 has value either 0 or 1.
I need to create in a result cell (C2), a comma-delimited list of the day numbers associated with a column B value of 1. In my example, from range B2:B33, cells B2, B4, B6 & B8 have a cell value 1, so C2 would contain the string 1, 3, 5, 7.
How can I accomplish that?
microsoft-excel
edited 6 hours ago
fixer1234
19.2k145082
asked 10 hours ago
SANKHA SUBHRA PAULSANKHA SUBHRA PAUL
6
New contributor
SANKHA SUBHRA PAUL is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
I have data consisting of day numbers, each with an associated 0/1 value. In the example below, A2:A32 has day number (like 1 in A2, 2 in A3 and so on through A31), B2:B32 has value either 0 or 1.
I need to create in a result cell (C2), a comma-delimited list of the day numbers associated with a column B value of 1. In my example, from range B2:B33, cells B2, B4, B6 & B8 have a cell value 1, so C2 would contain the string 1, 3, 5, 7.
How can I accomplish that?
microsoft-excel
edited 6 hours ago
fixer1234
19.2k145082
asked 10 hours ago
SANKHA SUBHRA PAULSANKHA SUBHRA PAUL
6
New contributor
SANKHA SUBHRA PAUL is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
2
We are not a code-writing service. You should include in the question what you have already tried and why it didn't work.
– harrymc
10 hours ago
add a comment |
I have data consisting of day numbers, each with an associated 0/1 value. In the example below, A2:A32 has day number (like 1 in A2, 2 in A3 and so on through A31), B2:B32 has value either 0 or 1.
I need to create in a result cell (C2), a comma-delimited list of the day numbers associated with a column B value of 1. In my example, from range B2:B33, cells B2, B4, B6 & B8 have a cell value 1, so C2 would contain the string 1, 3, 5, 7.
How can I accomplish that?
microsoft-excel
edited 6 hours ago
fixer1234
19.2k145082
asked 10 hours ago
SANKHA SUBHRA PAULSANKHA SUBHRA PAUL
6
New contributor
SANKHA SUBHRA PAUL is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I have data consisting of day numbers, each with an associated 0/1 value. In the example below, A2:A32 has day number (like 1 in A2, 2 in A3 and so on through A31), B2:B32 has value either 0 or 1.
I need to create in a result cell (C2), a comma-delimited list of the day numbers associated with a column B value of 1. In my example, from range B2:B33, cells B2, B4, B6 & B8 have a cell value 1, so C2 would contain the string 1, 3, 5, 7.
How can I accomplish that?
microsoft-excel
microsoft-excel
edited 6 hours ago
fixer1234
19.2k145082
asked 10 hours ago
SANKHA SUBHRA PAULSANKHA SUBHRA PAUL
6
New contributor
SANKHA SUBHRA PAUL is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited 6 hours ago
fixer1234
19.2k145082
asked 10 hours ago
SANKHA SUBHRA PAULSANKHA SUBHRA PAUL
6
New contributor
SANKHA SUBHRA PAUL is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited 6 hours ago
fixer1234
19.2k145082
edited 6 hours ago
fixer1234
19.2k145082
edited 6 hours ago
fixer1234
19.2k145082
19.2k145082
asked 10 hours ago
SANKHA SUBHRA PAULSANKHA SUBHRA PAUL
6
New contributor
SANKHA SUBHRA PAUL is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 10 hours ago
SANKHA SUBHRA PAULSANKHA SUBHRA PAUL
6
asked 10 hours ago
SANKHA SUBHRA PAULSANKHA SUBHRA PAUL
6
6
New contributor
SANKHA SUBHRA PAUL is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
SANKHA SUBHRA PAUL is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
SANKHA SUBHRA PAUL is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
2
We are not a code-writing service. You should include in the question what you have already tried and why it didn't work.
– harrymc
10 hours ago
add a comment |
2
We are not a code-writing service. You should include in the question what you have already tried and why it didn't work.
– harrymc
10 hours ago
2
2
We are not a code-writing service. You should include in the question what you have already tried and why it didn't work.
– harrymc
10 hours ago
We are not a code-writing service. You should include in the question what you have already tried and why it didn't work.
– harrymc
10 hours ago
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
});
}
});
SANKHA SUBHRA PAUL is a new contributor. Be nice, and check out our Code of Conduct.
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%2f1420548%2fconcatenate-values-from-qualifying-cells%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
SANKHA SUBHRA PAUL is a new contributor. Be nice, and check out our Code of Conduct.
SANKHA SUBHRA PAUL is a new contributor. Be nice, and check out our Code of Conduct.
SANKHA SUBHRA PAUL is a new contributor. Be nice, and check out our Code of Conduct.
SANKHA SUBHRA PAUL is a new contributor. Be nice, and check out our Code of Conduct.
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%2f1420548%2fconcatenate-values-from-qualifying-cells%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
We are not a code-writing service. You should include in the question what you have already tried and why it didn't work.
– harrymc
10 hours ago