using excel data validation to subset data
Could Sinn Fein swing any Brexit vote in Parliament?
Deletion of copy-ctor & copy-assignment - public, private or protected?
Relation between independence and correlation of uniform random variables
Can you move over difficult terrain with only 5 feet of movement?
Describing a chess game in a novel
Help prove this basic trig identity please!
Why is there so much iron?
Fewest number of steps to reach 200 using special calculator
Suggestions on how to spend Shaabath (constructively) alone
Generic TVP tradeoffs?
Print last inputted byte
Existence of a celestial body big enough for early civilization to be thought of as a second moon
Asserting that Atheism and Theism are both faith based positions
Variable completely messes up echoed string
Practical application of matrices and determinants
Violin - Can double stops be played when the strings are not next to each other?
Do US professors/group leaders only get a salary, but no group budget?
Probably overheated black color SMD pads
Wrapping homogeneous Python objects
What can I do if I am asked to learn different programming languages very frequently?
Are dual Irish/British citizens bound by the 90/180 day rule when travelling in the EU after Brexit?
What is the significance behind "40 days" that often appears in the Bible?
Writing in a Christian voice
Geography in 3D perspective
using excel data validation to subset data
I want to extract data from a table based on row (letter) names; e.g. the following table has 3 unique letters in each row: A, B, and C.
I want to set data validation for each of these unique letters; for instance, A with a "Yes or No" data validation option and so on. When I select "Yes" for any of the variables, the data from the original table will be copied to a separate table; e.g. if I select A (Yes), B (No), and C (Yes), the new filtered table will have a total of 4 rows summing 12.
In the attached excel file, I built an example where I only have a data validation cell to select one of the three letters to subset the data accordingly. What I am looking instead is an option to have "yes/No" for each of these three letters. I am trying to use VLOOKUP to get it work, but any other solution would be highly appreciated.
microsoft-excel
asked 1 min ago
ToNoYToNoY
14316
add a comment |
I want to extract data from a table based on row (letter) names; e.g. the following table has 3 unique letters in each row: A, B, and C.
I want to set data validation for each of these unique letters; for instance, A with a "Yes or No" data validation option and so on. When I select "Yes" for any of the variables, the data from the original table will be copied to a separate table; e.g. if I select A (Yes), B (No), and C (Yes), the new filtered table will have a total of 4 rows summing 12.
In the attached excel file, I built an example where I only have a data validation cell to select one of the three letters to subset the data accordingly. What I am looking instead is an option to have "yes/No" for each of these three letters. I am trying to use VLOOKUP to get it work, but any other solution would be highly appreciated.
microsoft-excel
asked 1 min ago
ToNoYToNoY
14316
add a comment |
I want to extract data from a table based on row (letter) names; e.g. the following table has 3 unique letters in each row: A, B, and C.
I want to set data validation for each of these unique letters; for instance, A with a "Yes or No" data validation option and so on. When I select "Yes" for any of the variables, the data from the original table will be copied to a separate table; e.g. if I select A (Yes), B (No), and C (Yes), the new filtered table will have a total of 4 rows summing 12.
In the attached excel file, I built an example where I only have a data validation cell to select one of the three letters to subset the data accordingly. What I am looking instead is an option to have "yes/No" for each of these three letters. I am trying to use VLOOKUP to get it work, but any other solution would be highly appreciated.
microsoft-excel
asked 1 min ago
ToNoYToNoY
14316
I want to extract data from a table based on row (letter) names; e.g. the following table has 3 unique letters in each row: A, B, and C.
I want to set data validation for each of these unique letters; for instance, A with a "Yes or No" data validation option and so on. When I select "Yes" for any of the variables, the data from the original table will be copied to a separate table; e.g. if I select A (Yes), B (No), and C (Yes), the new filtered table will have a total of 4 rows summing 12.
In the attached excel file, I built an example where I only have a data validation cell to select one of the three letters to subset the data accordingly. What I am looking instead is an option to have "yes/No" for each of these three letters. I am trying to use VLOOKUP to get it work, but any other solution would be highly appreciated.
microsoft-excel
microsoft-excel
asked 1 min ago
ToNoYToNoY
14316
asked 1 min ago
ToNoYToNoY
14316
asked 1 min ago
ToNoYToNoY
14316
asked 1 min ago
ToNoYToNoY
14316
asked 1 min ago
ToNoYToNoY
14316
14316
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%2f1414930%2fusing-excel-data-validation-to-subset-data%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%2f1414930%2fusing-excel-data-validation-to-subset-data%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
