Hi everyone,
I'm trying to sort my data by if the email address contains a company's name or not. But the Sort tool doesn't really work for that and I'm not looking to filter it out either. I want all the data to stay together just sorted so end users can see internal vs external clients in the reports more easily.
In the example below I'd like the Internal email addresses to be sorted by if it contains "Internal" and be on top of the other emails that don't contain "Internal".
Original Data
First Name | Last Name | |
Abe | Lincoln | Abe.Lincoln@Internal.com |
Jane | Doe | Jane.doe@External.com |
John | Smith | John.Smith@Internal.com |
Tom | Jefferson | Tom.Jefferson@External.com |
Desired Result
First Name | Last Name | |
Abe | Lincoln | Abe.Lincoln@Internal.com |
John | Smith | John.Smith@Internal.com |
Jane | Doe | Jane.doe@External.com |
Tom | Jefferson | Tom.Jefferson@External.com |
Thanks!
Solved! Go to Solution.
Would this work @jwlam? Just creates a flag where internal is lower than external and so when you sort ascending on the flag they'll all sit at the top. I can't think of any way to do the contains check and sort in one.
@DataNath That worked perfectly. Thanks!