I got a list of mail addresses, let's say we have the list
firstname.lastname@example.org email@example.com firstname.lastname@example.org email@example.com firstname.lastname@example.org email@example.com firstname.lastname@example.org email@example.com firstname.lastname@example.org
In Excel, how can I set up 2 rules of sorting? I like the first sort rule say that we sort alphabetically after the @ symbol.
The second sorting rule says that if the part after the @ symbol is same, then sort the part before the @ alphabetically.
So basically, the list above would look like that if we applied these 2 sorting rules:
email@example.com firstname.lastname@example.org email@example.com firstname.lastname@example.org email@example.com firstname.lastname@example.org email@example.com firstname.lastname@example.org email@example.com
I know how to set up the first rule in Excel at least. It's done by selecting the column to be sorted, copying it twice to another two columns, then in the second column select all mail addresses, press "Text in Columns" the seperate the mails when you see the symbol @. Then you have in the very first column the actual mail address, the second column you have the part before the @, the third column you have the part after the @. Now just let the column of the after @ part sort and you are done.
But I have no idea how to take both rules into account at the same time...? :S
I really hope my question is clear because else I will have a very long day tomorrow at work :P