Home

Help me get my dream job (Sorting per multiple row conditions) WARNING: Complicated

%3CLINGO-SUB%20id%3D%22lingo-sub-400715%22%20slang%3D%22en-US%22%3EHelp%20me%20get%20my%20dream%20job%20(Sorting%20per%20multiple%20row%20conditions)%20WARNING%3A%20Complicated%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-400715%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EHey%20guys%2C%26nbsp%3B%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3Eso%20I'm%20currently%20on%20an%20internship%20for%20a%20major%20tech%20company%20and%20they've%20lightheartedly%20said%20that%20if%20I%20fix%20a%20specific%20IT%20issue%2C%20they%20will%20give%20me%20a%20job%20there.%26nbsp%3B%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3E...However%2C%20in%20order%20for%20me%20to%20fix%20this%2C%20I%20need%20to%20manage%20a%20tremendous%20amount%20of%20data%20and%20sort%20it%20in%20a%20very%20specific%20manner.%26nbsp%3B%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EThe%20bottom%20line%20is%3A%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EI%20want%20Excel%20to%20sort%20data%20based%20on%20whether%20or%20not%20TWO%20fields%20have%20equal%20content.%20This%20might%20get%20complicated%2C%20but%20I'll%20try%20my%20best%20to%20explain.%20I've%20attached%20a%20screenshot%20of%20a%20small%20snippet%20of%20the%20spreadsheet%20with%20the%20categories.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CIMG%20src%3D%22https%3A%2F%2Fpasteboard.co%2FI8Ick88.png%22%20border%3D%220%22%20alt%3D%22%22%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F105882i511C7DDDF171FA48%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Capture.PNG%22%20title%3D%22Capture.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EBasically%20I%20need%20it%20to%20sort%20depending%20on%20whether%20the%20following%20conditions%20are%20met%20within%20TWO%20ROWS%3A%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3E%22FAQ%20GUID%22%20needs%20to%20have%20the%20same%20value%20on%20both%20rows%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E%22Mapping%201%22%20needs%20to%20contain%20the%20content%20%22Classification%20one%22%20and%20%22Classification%20two%22%20on%20the%20the%20rows%20respectively.%26nbsp%3B%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E%22Conditions%20title%22%20need%20to%20have%20the%20same%20two%20pieces%20of%20content%2C%20like%20%22ID%2BV%22%20after%20%22Classification%20one%22%20and%20%22Escalation%22%20after%20%22Classification%20two%22.%26nbsp%3B%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EHowever%2C%20I%20need%20it%20to%20also%20sort%20those%20cases%20by%20grouping%20together%20the%20rest%20of%20the%20identical%20%22FAQ%20GUID%22.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EBasically%20I%20want%20Excel%20to%20bunch%20together%20FAQ%20GUID%20cases%20where%20the%20two%20classifications%2C%20Classification%20One%20and%20Classification%20Two%2C%20match%20up%20in%20their%20following%20%22Condition%20Title%22%20content%2C%20like%20all%20cases%20where%20ID%2BV%20and%20Escalation%20are%20both%20present%20as%20in%20the%20screenshot%20attached.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EIn%20case%20this%20sounds%20crazy%20or%20nonsensical%2C%20a%20bit%20of%20background%20story%20might%20help%20on%20what%20I'm%20trying%20to%20achieve%2C%20in%20case%20you%20have%20a%20some%20tips%3A%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EI%20need%20to%20group%20together%208%20versions%20of%20all%20FAQs%20together%2C%20one%20for%20each%20language%2C%20and%20the%20only%20thing%20they%20have%20in%20common%20is%20that%20their%20classification%20one%20and%20classification%20two%20are%20the%20same.%20However%2C%20as%20I%20have%2080.000%20rows%2C%20this%20would%20take%20literally%20a%20month%20to%20do%20if%20I%20can't%20do%20it%20automatically.%26nbsp%3B%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EAny%20help%20guys%3F%20My%20apologies%20if%20this%20seems%20messy%2C%20as%20you%20might%20have%20guessed%20I'm%20not%20the%20most%20Excel%20savvy%20guy%20but%20I%20learn%20fast%20so%20go%20nuts.%26nbsp%3B%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EMy%20own%20theories%20include%3A%26nbsp%3B%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EUsing%20functions%20to%20meet%20the%20three%20conditions.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EUsing%20color%20to%20eliminate%201%20out%20of%203%20conditions%20(coloring%20all%20Classification%20one%20rows%20green%20for%20example)%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EKind%20regards%2C%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EJames%20Stewart%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-400715%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-406998%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20me%20get%20my%20dream%20job%20(Sorting%20per%20multiple%20row%20conditions)%20WARNING%3A%20Complicated%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-406998%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F314823%22%20target%3D%22_blank%22%3E%40JamesStewartExcel%3C%2FA%3E%26nbsp%3Bhave%20you%20the%20authority%20to%20add%20columns%20(and%20maybe%20hide%20them)%20in%20this%20file%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20combine%20the%20columns%20you%20need%20(A%26amp%3BQ%26amp%3BS)%20to%20read%20out%20the%20string%2Bclassification1%2Bidv%20and%20then%20assign%20a%20rank%20based%20on%20the%20order%20pointed%20out%3B%20then%20order%20by%20that%20new%20column%20and%20voil%C3%A0...%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-407569%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20me%20get%20my%20dream%20job%20(Sorting%20per%20multiple%20row%20conditions)%20WARNING%3A%20Complicated%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-407569%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F152529%22%20target%3D%22_blank%22%3E%40Arul%20Tresoldi%3C%2FA%3E%26nbsp%3BHey%20Arul!%20This%20sounds%20very%20interesting%2C%20I%20hadn't%20considered%20this%20at%20all.%20I%20have%20absolute%20freedom%20with%20the%20spreadsheet.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3ECould%20you%20clarify%20or%20explain%20a%20bit%20more%20about%20this%20approach%3F%20I'm%20not%20entirely%20sure%20I%20understand%20what%20you%20mean%20about%20combining%20them%20and%20reading%20it.%20But%20I'd%20love%20to%20hear%20more%20about%20it!%3C%2FP%3E%3C%2FLINGO-BODY%3E
JamesStewartExcel
Occasional Contributor

Hey guys, 


so I'm currently on an internship for a major tech company and they've lightheartedly said that if I fix a specific IT issue, they will give me a job there. 


...However, in order for me to fix this, I need to manage a tremendous amount of data and sort it in a very specific manner. 
The bottom line is:


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.

Capture.PNG



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 1 out of 3 conditions (coloring all Classification one rows green for example)


Kind regards,


James Stewart

 

2 Replies

@JamesStewartExcel have you the authority to add columns (and maybe hide them) in this file?

 

You can combine the columns you need (A&Q&S) to read out the string+classification1+idv and then assign a rank based on the order pointed out; then order by that new column and voilà...

@Arul Tresoldi Hey Arul! This sounds very interesting, I hadn't considered this at all. I have absolute freedom with the spreadsheet. 

Could you clarify or explain a bit more about this approach? I'm not entirely sure I understand what you mean about combining them and reading it. But I'd love to hear more about it!

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies