#1
|
|||
|
|||
Sorting per multiple row conditions
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. (Link removed by moderation) <a href="https://ibb.co/rkyBYPG"><img src="https://i.ibb.co/8M8yq3D/Capture.png" alt="Capture" border="0"></a> 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 Last edited by Pecoflyer; 04-05-2019 at 11:20 PM. Reason: Removed link |
#2
|
||||
|
||||
Hi and welcome
please post a sample sheet with some data and expeted results ( no pics please) I also removed links to external sites as they are potentially dangerous, and not all our members can access them. Post on the board instead Also please avoid unnecessary items in your thread title . I corrected it for you Thanks
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
Tags |
functions, programming |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
IF formula - multiple conditions | rameen | Excel | 1 | 02-11-2019 12:37 AM |
Alternative for Multiple If Conditions? | zguan1 | Excel | 2 | 05-25-2017 09:12 AM |
I need help with Sorting and adding cells, it sound basis however it is more complicated than that. | will soar | Excel | 2 | 02-23-2017 01:38 PM |
Multiple If Conditions | z941714 | Excel | 8 | 08-09-2015 04:12 PM |
Count with multiple conditions | bundy5150 | Excel | 4 | 02-22-2011 10:00 AM |