Autogenerate category based on unique combinations of cellsHow to identify cells in Column A that contain any...
Can one be a co-translator of a book, if he does not know the language that the book is translated into?
What is the intuition behind short exact sequences of groups; in particular, what is the intuition behind group extensions?
Western buddy movie with a supernatural twist where a woman turns into an eagle at the end
What killed these X2 caps?
Do I have a twin with permutated remainders?
Watching something be written to a file live with tail
Why is it a bad idea to hire a hitman to eliminate most corrupt politicians?
How do conventional missiles fly?
What is the most common color to indicate the input-field is disabled?
In Romance of the Three Kingdoms why do people still use bamboo sticks when paper had already been invented?
How to prevent "they're falling in love" trope
Can a rocket refuel on Mars from water?
Stopping power of mountain vs road bike
Theorems that impeded progress
Why doesn't H₄O²⁺ exist?
What to put in ESTA if staying in US for a few days before going on to Canada
I Accidentally Deleted a Stock Terminal Theme
Why was the shrinking from 8″ made only to 5.25″ and not smaller (4″ or less)?
What exploit are these user agents trying to use?
What's the point of deactivating Num Lock on login screens?
How can saying a song's name be a copyright violation?
Anagram holiday
1960's book about a plague that kills all white people
How could indestructible materials be used in power generation?
Autogenerate category based on unique combinations of cells
How to identify cells in Column A that contain any of the values in Column BIn Excel I need to find data matches between two arrays - one horizontal and one verticalHow to print two different sheets with different scale options using Excel 2007 and Excel 2010?Excel: Calculate IF column based on another IF columnHow do I externally reference rows from one sheet to another based on a non-numerical condition in one column no the original sheet?Creating a list of unique combinations in sheetIf Statement -Multiple yes/no column conditions simplify a growing nested IF AND formula?Can Excel generate a percentage chart from a column with CSV values? How?Add value based on CategoryHaving trouble comparing multiple columns and rows in different worksheets in excel
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
This seems more confusing than it really is, but I have an Excel sheet that categorizes different combinations of answers.
Each category or tier is based on a unique combination of Yes and No answers between 7 columns.
e.g.:
I'm looking for a way where I can have a blank sheet, and when a user fills in the Yes/No answers, the Tier # will auto-generate based on their responses.
Right now the only possible solution in my limited knowledge is a really long nested IF statement.
Surely a better way exists in Excel? Thanks in advance!!
microsoft-excel worksheet-function
asked 10 hours ago
An NuyenAn Nuyen
11
New contributor
An Nuyen 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 |
This seems more confusing than it really is, but I have an Excel sheet that categorizes different combinations of answers.
Each category or tier is based on a unique combination of Yes and No answers between 7 columns.
e.g.:
I'm looking for a way where I can have a blank sheet, and when a user fills in the Yes/No answers, the Tier # will auto-generate based on their responses.
Right now the only possible solution in my limited knowledge is a really long nested IF statement.
Surely a better way exists in Excel? Thanks in advance!!
microsoft-excel worksheet-function
asked 10 hours ago
An NuyenAn Nuyen
11
New contributor
An Nuyen 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 |
This seems more confusing than it really is, but I have an Excel sheet that categorizes different combinations of answers.
Each category or tier is based on a unique combination of Yes and No answers between 7 columns.
e.g.:
I'm looking for a way where I can have a blank sheet, and when a user fills in the Yes/No answers, the Tier # will auto-generate based on their responses.
Right now the only possible solution in my limited knowledge is a really long nested IF statement.
Surely a better way exists in Excel? Thanks in advance!!
microsoft-excel worksheet-function
asked 10 hours ago
An NuyenAn Nuyen
11
New contributor
An Nuyen is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
This seems more confusing than it really is, but I have an Excel sheet that categorizes different combinations of answers.
Each category or tier is based on a unique combination of Yes and No answers between 7 columns.
e.g.:
I'm looking for a way where I can have a blank sheet, and when a user fills in the Yes/No answers, the Tier # will auto-generate based on their responses.
Right now the only possible solution in my limited knowledge is a really long nested IF statement.
Surely a better way exists in Excel? Thanks in advance!!
microsoft-excel worksheet-function
microsoft-excel worksheet-function
asked 10 hours ago
An NuyenAn Nuyen
11
New contributor
An Nuyen 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
An NuyenAn Nuyen
11
New contributor
An Nuyen is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited 9 hours ago
An Nuyen
asked 10 hours ago
An NuyenAn Nuyen
11
New contributor
An Nuyen 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
An NuyenAn Nuyen
11
asked 10 hours ago
An NuyenAn Nuyen
11
11
New contributor
An Nuyen is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
An Nuyen is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
An Nuyen 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 |
add a comment |
1 Answer
1
active
oldest
votes
This can be done in Excel 2016 with a helper column and TEXTJOIN.
Assuming the list of Tiers is in Sheet2, add a column with the following formula in it:
=TEXTJOIN(,TRUE,B2:H2)
Then in Sheet1, add the following formula where you want the tier to appear:
=INDEX(Sheet2!A$2:A$6,(MATCH(TEXTJOIN(,TRUE,B2:H2),Sheet2!I$2:I$6,0)))
TEXTJOIN will essentially convert all y/n values into a single string. MATCH will then look for the matching string on Sheet2 and INDEX will return the corresponding tier.
answered 9 hours ago
cybernetic.nomadcybernetic.nomad
2,651617
There's definitely something useful about converting the line into a single string, but I can't quite get the =INDEX part you suggested to work...it basically just copies over the column of Tier names instead of selecting the appropriate/matching Tier.
– An Nuyen
9 hours ago
Quite correct: I forgot to make one of the references absolute. See my edited answer
– cybernetic.nomad
9 hours ago
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
});
}
});
An Nuyen 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%2f1421538%2fautogenerate-category-based-on-unique-combinations-of-cells%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
This can be done in Excel 2016 with a helper column and TEXTJOIN.
Assuming the list of Tiers is in Sheet2, add a column with the following formula in it:
=TEXTJOIN(,TRUE,B2:H2)
Then in Sheet1, add the following formula where you want the tier to appear:
=INDEX(Sheet2!A$2:A$6,(MATCH(TEXTJOIN(,TRUE,B2:H2),Sheet2!I$2:I$6,0)))
TEXTJOIN will essentially convert all y/n values into a single string. MATCH will then look for the matching string on Sheet2 and INDEX will return the corresponding tier.
answered 9 hours ago
cybernetic.nomadcybernetic.nomad
2,651617
There's definitely something useful about converting the line into a single string, but I can't quite get the =INDEX part you suggested to work...it basically just copies over the column of Tier names instead of selecting the appropriate/matching Tier.
– An Nuyen
9 hours ago
Quite correct: I forgot to make one of the references absolute. See my edited answer
– cybernetic.nomad
9 hours ago
add a comment |
This can be done in Excel 2016 with a helper column and TEXTJOIN.
Assuming the list of Tiers is in Sheet2, add a column with the following formula in it:
=TEXTJOIN(,TRUE,B2:H2)
Then in Sheet1, add the following formula where you want the tier to appear:
=INDEX(Sheet2!A$2:A$6,(MATCH(TEXTJOIN(,TRUE,B2:H2),Sheet2!I$2:I$6,0)))
TEXTJOIN will essentially convert all y/n values into a single string. MATCH will then look for the matching string on Sheet2 and INDEX will return the corresponding tier.
answered 9 hours ago
cybernetic.nomadcybernetic.nomad
2,651617
There's definitely something useful about converting the line into a single string, but I can't quite get the =INDEX part you suggested to work...it basically just copies over the column of Tier names instead of selecting the appropriate/matching Tier.
– An Nuyen
9 hours ago
Quite correct: I forgot to make one of the references absolute. See my edited answer
– cybernetic.nomad
9 hours ago
add a comment |
This can be done in Excel 2016 with a helper column and TEXTJOIN.
Assuming the list of Tiers is in Sheet2, add a column with the following formula in it:
=TEXTJOIN(,TRUE,B2:H2)
Then in Sheet1, add the following formula where you want the tier to appear:
=INDEX(Sheet2!A$2:A$6,(MATCH(TEXTJOIN(,TRUE,B2:H2),Sheet2!I$2:I$6,0)))
TEXTJOIN will essentially convert all y/n values into a single string. MATCH will then look for the matching string on Sheet2 and INDEX will return the corresponding tier.
answered 9 hours ago
cybernetic.nomadcybernetic.nomad
2,651617
This can be done in Excel 2016 with a helper column and TEXTJOIN.
Assuming the list of Tiers is in Sheet2, add a column with the following formula in it:
=TEXTJOIN(,TRUE,B2:H2)
Then in Sheet1, add the following formula where you want the tier to appear:
=INDEX(Sheet2!A$2:A$6,(MATCH(TEXTJOIN(,TRUE,B2:H2),Sheet2!I$2:I$6,0)))
TEXTJOIN will essentially convert all y/n values into a single string. MATCH will then look for the matching string on Sheet2 and INDEX will return the corresponding tier.
answered 9 hours ago
cybernetic.nomadcybernetic.nomad
2,651617
edited 9 hours ago
answered 9 hours ago
cybernetic.nomadcybernetic.nomad
2,651617
answered 9 hours ago
cybernetic.nomadcybernetic.nomad
2,651617
answered 9 hours ago
cybernetic.nomadcybernetic.nomad
2,651617
2,651617
There's definitely something useful about converting the line into a single string, but I can't quite get the =INDEX part you suggested to work...it basically just copies over the column of Tier names instead of selecting the appropriate/matching Tier.
– An Nuyen
9 hours ago
Quite correct: I forgot to make one of the references absolute. See my edited answer
– cybernetic.nomad
9 hours ago
add a comment |
There's definitely something useful about converting the line into a single string, but I can't quite get the =INDEX part you suggested to work...it basically just copies over the column of Tier names instead of selecting the appropriate/matching Tier.
– An Nuyen
9 hours ago
Quite correct: I forgot to make one of the references absolute. See my edited answer
– cybernetic.nomad
9 hours ago
There's definitely something useful about converting the line into a single string, but I can't quite get the =INDEX part you suggested to work...it basically just copies over the column of Tier names instead of selecting the appropriate/matching Tier.
– An Nuyen
9 hours ago
There's definitely something useful about converting the line into a single string, but I can't quite get the =INDEX part you suggested to work...it basically just copies over the column of Tier names instead of selecting the appropriate/matching Tier.
– An Nuyen
9 hours ago
Quite correct: I forgot to make one of the references absolute. See my edited answer
– cybernetic.nomad
9 hours ago
Quite correct: I forgot to make one of the references absolute. See my edited answer
– cybernetic.nomad
9 hours ago
add a comment |
An Nuyen is a new contributor. Be nice, and check out our Code of Conduct.
An Nuyen is a new contributor. Be nice, and check out our Code of Conduct.
An Nuyen is a new contributor. Be nice, and check out our Code of Conduct.
An Nuyen 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%2f1421538%2fautogenerate-category-based-on-unique-combinations-of-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
