Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-05-2019, 03:33 AM
JamesTheNoob JamesTheNoob is offline Sorting per multiple row conditions Windows 10 Sorting per multiple row conditions Office 2016
Novice
Sorting per multiple row conditions
 
Join Date: Apr 2019
Posts: 5
JamesTheNoob is on a distinguished road
Exclamation 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
Attached Images
File Type: png Capture.PNG (94.2 KB, 14 views)

Last edited by Pecoflyer; 04-05-2019 at 11:20 PM. Reason: Removed link
Reply With Quote
  #2  
Old 04-05-2019, 11:20 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Sorting per multiple row conditions Windows 7 64bit Sorting per multiple row conditions Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
Reply With Quote
Reply

Tags
functions, programming

Thread Tools
Display Modes


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
Sorting per multiple row conditions Multiple If Conditions z941714 Excel 8 08-09-2015 04:12 PM
Sorting per multiple row conditions Count with multiple conditions bundy5150 Excel 4 02-22-2011 10:00 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:24 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft