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

JamesTheNoob

New Member
Joined
Apr 5, 2019
Messages
4
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.




https://ibb.co/rkyBYPG
I8Ick88.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
 

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.
I8Ick88.png
https://pasteboard.co/I8Ick88.png

<a href="https://ibb.co/rkyBYPG"><img src="https://i.ibb.co/8M8yq3D/Capture.png" alt="Capture" border="0"></a>
 
Upvote 0

Forum statistics

Threads
1,213,510
Messages
6,114,037
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top