this questions doesn't have to do with video editing directly. it's an excel question and I hope someone can help me. I've been trying to get this done for like an hour now with no luck.
i have a list of my clients emails in alphabetical order descending based on the first character but I want them to be in alphabetical order + order by domain name for example:
instead of having:
johndoe1@yahoo.com
johnydoe1@hotmail.com
koolerguy1@aol.com
koolguy13@yahoo.com
zenzo@aol.com
I want it to be:
koolerguy1@aol.com
zenzo@aol.com
johnydoe1@hotmail.com
johndoe1@yahoo.com
koolguy13@yahoo.com
See how it's alphabetical by name and domain aol, then hotmail, then yahoo
If anyone can figure out how to solve this problem I will be forever greatful!
i have a list of my clients emails in alphabetical order descending based on the first character but I want them to be in alphabetical order + order by domain name for example:
instead of having:
johndoe1@yahoo.com
johnydoe1@hotmail.com
koolerguy1@aol.com
koolguy13@yahoo.com
zenzo@aol.com
I want it to be:
koolerguy1@aol.com
zenzo@aol.com
johnydoe1@hotmail.com
johndoe1@yahoo.com
koolguy13@yahoo.com
See how it's alphabetical by name and domain aol, then hotmail, then yahoo
If anyone can figure out how to solve this problem I will be forever greatful!