Advanced Excel sorting issue with multiple row conditionsHow to get excel row numbers to skip the headerExcel...
What typically incentivizes a professor to change jobs to a lower ranking university?
How to write a macro that is braces sensitive?
What are these boxed doors outside store fronts in New York?
Prove that NP is closed under karp reduction?
What defenses are there against being summoned by the Gate spell?
Mathematical cryptic clues
Why not use SQL instead of GraphQL?
Today is the Center
How can I prevent hyper evolved versions of regular creatures from wiping out their cousins?
What does it mean to describe someone as a butt steak?
In Japanese, what’s the difference between “Tonari ni” (となりに) and “Tsugi” (つぎ)? When would you use one over the other?
How do we improve the relationship with a client software team that performs poorly and is becoming less collaborative?
How does strength of boric acid solution increase in presence of salicylic acid?
Can divisibility rules for digits be generalized to sum of digits
Service Entrance Breakers Rain Shield
How to say job offer in Mandarin/Cantonese?
How can I make my BBEG immortal short of making them a Lich or Vampire?
How to format long polynomial?
How do I create uniquely male characters?
What does "Puller Prush Person" mean?
How is it possible to have an ability score that is less than 3?
Problem of parity - Can we draw a closed path made up of 20 line segments...
Is this a crack on the carbon frame?
Do I have a twin with permutated remainders?
Advanced Excel sorting issue with multiple row conditions
How to get excel row numbers to skip the headerExcel combine multiple rows with IDInsert blank row on two conditionsHow can I sort data that is organized in 4-row chunks?Sort Excel Row Based on Values in Another RowExcel: delete row if empty cell condition is true across multiple columnsExcel sort does not sort numeric valuesHow can I make Excel print row by row, one page wide?Excel text + numerical sorting?Keep rows together while sorting in Excel
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
I want Excel to sort data based on whether or not TWO fields have equal content. This might get complicated, but I'll try my best to explain. I've attached a screenshot of a small snippet of the spreadsheet with the categories.
Basically I need it to sort depending on whether the following conditions are met within TWO ROWS:
"FAQ GUID" needs to have the same value on both rows
"Mapping 1" needs to contain the content "Classification one" and "Classification two" on the the rows respectively.
"Conditions title" need to have the same two pieces of content, like "ID+V" after "Classification one" and "Escalation" after "Classification two".
However, I need it to also sort those cases by grouping together the rest of the identical "FAQ GUID".
Basically I want Excel to bunch together FAQ GUID cases where the two classifications, Classification One and Classification Two, match up in their following "Condition Title" content, like all cases where ID+V and Escalation are both present as in the screenshot attached.
In case this sounds crazy or nonsensical, a bit of background story might help on what I'm trying to achieve, in case you have a some tips:
I need to group together 8 versions of all FAQs together, one for each language, and the only thing they have in common is that their classification one and classification two are the same. However, as I have 80.000 rows, this would take literally a month to do if I can't do it automatically.
Any help guys? My apologies if this seems messy, as you might have guessed I'm not the most Excel savvy guy but I learn fast so go nuts.
My own theories include:
Using functions to meet the three conditions.
Using color to eliminate one out of three conditions (coloring all Classification one rows green for example)
microsoft-excel sorting
edited yesterday
Twisty Impersonator
18.7k1468100
asked yesterday
JamesJames
1
New contributor
James 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 want Excel to sort data based on whether or not TWO fields have equal content. This might get complicated, but I'll try my best to explain. I've attached a screenshot of a small snippet of the spreadsheet with the categories.
Basically I need it to sort depending on whether the following conditions are met within TWO ROWS:
"FAQ GUID" needs to have the same value on both rows
"Mapping 1" needs to contain the content "Classification one" and "Classification two" on the the rows respectively.
"Conditions title" need to have the same two pieces of content, like "ID+V" after "Classification one" and "Escalation" after "Classification two".
However, I need it to also sort those cases by grouping together the rest of the identical "FAQ GUID".
Basically I want Excel to bunch together FAQ GUID cases where the two classifications, Classification One and Classification Two, match up in their following "Condition Title" content, like all cases where ID+V and Escalation are both present as in the screenshot attached.
In case this sounds crazy or nonsensical, a bit of background story might help on what I'm trying to achieve, in case you have a some tips:
I need to group together 8 versions of all FAQs together, one for each language, and the only thing they have in common is that their classification one and classification two are the same. However, as I have 80.000 rows, this would take literally a month to do if I can't do it automatically.
Any help guys? My apologies if this seems messy, as you might have guessed I'm not the most Excel savvy guy but I learn fast so go nuts.
My own theories include:
Using functions to meet the three conditions.
Using color to eliminate one out of three conditions (coloring all Classification one rows green for example)
microsoft-excel sorting
edited yesterday
Twisty Impersonator
18.7k1468100
asked yesterday
JamesJames
1
New contributor
James is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
1
If I solve it, do I get the job at said major tech company?
– spikey_richie
yesterday
1
I don't have time to delve into the problem fully, but is what you will want to do is create helper columns to test whether logic is met or not, and then sort on these. you can use 1 and 0 in place of true and false, and then sum the 1s etc. to create a proper hierarchical ranking system.
– PeterH
yesterday
I'm not exactly clear on the spec here - you need to sort, or filter? this sentence "cases where the two classifications, Classification One and Classification Two, match up in their following "Condition Title" content, like all cases where ID+V and Escalation are both present as in the screenshot attached." seems contradictory... etc. Regardless, @PeterH has it right - for each condition as you understand it, create a helper column to test against that condition. If you run into any specific snags, post back. You should be able to step towards a solution that way.
– Alex M
yesterday
add a comment |
I want Excel to sort data based on whether or not TWO fields have equal content. This might get complicated, but I'll try my best to explain. I've attached a screenshot of a small snippet of the spreadsheet with the categories.
Basically I need it to sort depending on whether the following conditions are met within TWO ROWS:
"FAQ GUID" needs to have the same value on both rows
"Mapping 1" needs to contain the content "Classification one" and "Classification two" on the the rows respectively.
"Conditions title" need to have the same two pieces of content, like "ID+V" after "Classification one" and "Escalation" after "Classification two".
However, I need it to also sort those cases by grouping together the rest of the identical "FAQ GUID".
Basically I want Excel to bunch together FAQ GUID cases where the two classifications, Classification One and Classification Two, match up in their following "Condition Title" content, like all cases where ID+V and Escalation are both present as in the screenshot attached.
In case this sounds crazy or nonsensical, a bit of background story might help on what I'm trying to achieve, in case you have a some tips:
I need to group together 8 versions of all FAQs together, one for each language, and the only thing they have in common is that their classification one and classification two are the same. However, as I have 80.000 rows, this would take literally a month to do if I can't do it automatically.
Any help guys? My apologies if this seems messy, as you might have guessed I'm not the most Excel savvy guy but I learn fast so go nuts.
My own theories include:
Using functions to meet the three conditions.
Using color to eliminate one out of three conditions (coloring all Classification one rows green for example)
microsoft-excel sorting
edited yesterday
Twisty Impersonator
18.7k1468100
asked yesterday
JamesJames
1
New contributor
James is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I want Excel to sort data based on whether or not TWO fields have equal content. This might get complicated, but I'll try my best to explain. I've attached a screenshot of a small snippet of the spreadsheet with the categories.
Basically I need it to sort depending on whether the following conditions are met within TWO ROWS:
"FAQ GUID" needs to have the same value on both rows
"Mapping 1" needs to contain the content "Classification one" and "Classification two" on the the rows respectively.
"Conditions title" need to have the same two pieces of content, like "ID+V" after "Classification one" and "Escalation" after "Classification two".
However, I need it to also sort those cases by grouping together the rest of the identical "FAQ GUID".
Basically I want Excel to bunch together FAQ GUID cases where the two classifications, Classification One and Classification Two, match up in their following "Condition Title" content, like all cases where ID+V and Escalation are both present as in the screenshot attached.
In case this sounds crazy or nonsensical, a bit of background story might help on what I'm trying to achieve, in case you have a some tips:
I need to group together 8 versions of all FAQs together, one for each language, and the only thing they have in common is that their classification one and classification two are the same. However, as I have 80.000 rows, this would take literally a month to do if I can't do it automatically.
Any help guys? My apologies if this seems messy, as you might have guessed I'm not the most Excel savvy guy but I learn fast so go nuts.
My own theories include:
Using functions to meet the three conditions.
Using color to eliminate one out of three conditions (coloring all Classification one rows green for example)
microsoft-excel sorting
microsoft-excel sorting
edited yesterday
Twisty Impersonator
18.7k1468100
asked yesterday
JamesJames
1
New contributor
James is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited yesterday
Twisty Impersonator
18.7k1468100
asked yesterday
JamesJames
1
New contributor
James is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited yesterday
Twisty Impersonator
18.7k1468100
edited yesterday
Twisty Impersonator
18.7k1468100
edited yesterday
Twisty Impersonator
18.7k1468100
18.7k1468100
asked yesterday
JamesJames
1
New contributor
James is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked yesterday
JamesJames
1
asked yesterday
JamesJames
1
1
New contributor
James is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
James is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
James is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
1
If I solve it, do I get the job at said major tech company?
– spikey_richie
yesterday
1
I don't have time to delve into the problem fully, but is what you will want to do is create helper columns to test whether logic is met or not, and then sort on these. you can use 1 and 0 in place of true and false, and then sum the 1s etc. to create a proper hierarchical ranking system.
– PeterH
yesterday
I'm not exactly clear on the spec here - you need to sort, or filter? this sentence "cases where the two classifications, Classification One and Classification Two, match up in their following "Condition Title" content, like all cases where ID+V and Escalation are both present as in the screenshot attached." seems contradictory... etc. Regardless, @PeterH has it right - for each condition as you understand it, create a helper column to test against that condition. If you run into any specific snags, post back. You should be able to step towards a solution that way.
– Alex M
yesterday
add a comment |
1
If I solve it, do I get the job at said major tech company?
– spikey_richie
yesterday
1
I don't have time to delve into the problem fully, but is what you will want to do is create helper columns to test whether logic is met or not, and then sort on these. you can use 1 and 0 in place of true and false, and then sum the 1s etc. to create a proper hierarchical ranking system.
– PeterH
yesterday
I'm not exactly clear on the spec here - you need to sort, or filter? this sentence "cases where the two classifications, Classification One and Classification Two, match up in their following "Condition Title" content, like all cases where ID+V and Escalation are both present as in the screenshot attached." seems contradictory... etc. Regardless, @PeterH has it right - for each condition as you understand it, create a helper column to test against that condition. If you run into any specific snags, post back. You should be able to step towards a solution that way.
– Alex M
yesterday
1
1
If I solve it, do I get the job at said major tech company?
– spikey_richie
yesterday
If I solve it, do I get the job at said major tech company?
– spikey_richie
yesterday
1
1
I don't have time to delve into the problem fully, but is what you will want to do is create helper columns to test whether logic is met or not, and then sort on these. you can use 1 and 0 in place of true and false, and then sum the 1s etc. to create a proper hierarchical ranking system.
– PeterH
yesterday
I don't have time to delve into the problem fully, but is what you will want to do is create helper columns to test whether logic is met or not, and then sort on these. you can use 1 and 0 in place of true and false, and then sum the 1s etc. to create a proper hierarchical ranking system.
– PeterH
yesterday
I'm not exactly clear on the spec here - you need to sort, or filter? this sentence "cases where the two classifications, Classification One and Classification Two, match up in their following "Condition Title" content, like all cases where ID+V and Escalation are both present as in the screenshot attached." seems contradictory... etc. Regardless, @PeterH has it right - for each condition as you understand it, create a helper column to test against that condition. If you run into any specific snags, post back. You should be able to step towards a solution that way.
– Alex M
yesterday
I'm not exactly clear on the spec here - you need to sort, or filter? this sentence "cases where the two classifications, Classification One and Classification Two, match up in their following "Condition Title" content, like all cases where ID+V and Escalation are both present as in the screenshot attached." seems contradictory... etc. Regardless, @PeterH has it right - for each condition as you understand it, create a helper column to test against that condition. If you run into any specific snags, post back. You should be able to step towards a solution that way.
– Alex M
yesterday
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
});
}
});
James 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%2f1421902%2fadvanced-excel-sorting-issue-with-multiple-row-conditions%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
James is a new contributor. Be nice, and check out our Code of Conduct.
James is a new contributor. Be nice, and check out our Code of Conduct.
James is a new contributor. Be nice, and check out our Code of Conduct.
James 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%2f1421902%2fadvanced-excel-sorting-issue-with-multiple-row-conditions%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
1
If I solve it, do I get the job at said major tech company?
– spikey_richie
yesterday
1
I don't have time to delve into the problem fully, but is what you will want to do is create helper columns to test whether logic is met or not, and then sort on these. you can use 1 and 0 in place of true and false, and then sum the 1s etc. to create a proper hierarchical ranking system.
– PeterH
yesterday
I'm not exactly clear on the spec here - you need to sort, or filter? this sentence "cases where the two classifications, Classification One and Classification Two, match up in their following "Condition Title" content, like all cases where ID+V and Escalation are both present as in the screenshot attached." seems contradictory... etc. Regardless, @PeterH has it right - for each condition as you understand it, create a helper column to test against that condition. If you run into any specific snags, post back. You should be able to step towards a solution that way.
– Alex M
yesterday