Hi
Column A: "First Name"
Column B: "Last Name"
Column C: "Role"
Column D: "Group"
"Role" can be a text string of A, B or C followed by a number of 1 to 8
"Group" is a number from 0 to 7
I want to apply the following sort order:
1. Group first in ascending numerical order
2. Role in ascending alphabetical order looking at only the first letter (ignoring the number)
3. First Name in ascending alphabetical order
4. Last Name in ascending alphabetical order
I'm having an issue with the 2nd Sort Key. I want it to put all the As first in ascending Name alphabetical order and then all the Bs and Cs together in Name ascending alphabetical order. So you would ultimately end up with Bs and Cs mixed together in a random order that depends on the persons First Name
If I simply just set the 2nd Sort Key to Column C, it orders them in alphanumerical order (which you would expect): A1, A2, A3, etc, up to C8. If I remove the 2nd Sort Key (sort by role) it is almost as I want it to be, but then the As are all mixed together.
Is there a Custom Order I can set that will solve this?
I hope I've explained myself well enough and I'm hoping someone can help me out.
Thanks
Liam
Column A: "First Name"
Column B: "Last Name"
Column C: "Role"
Column D: "Group"
"Role" can be a text string of A, B or C followed by a number of 1 to 8
"Group" is a number from 0 to 7
I want to apply the following sort order:
1. Group first in ascending numerical order
2. Role in ascending alphabetical order looking at only the first letter (ignoring the number)
3. First Name in ascending alphabetical order
4. Last Name in ascending alphabetical order
I'm having an issue with the 2nd Sort Key. I want it to put all the As first in ascending Name alphabetical order and then all the Bs and Cs together in Name ascending alphabetical order. So you would ultimately end up with Bs and Cs mixed together in a random order that depends on the persons First Name
If I simply just set the 2nd Sort Key to Column C, it orders them in alphanumerical order (which you would expect): A1, A2, A3, etc, up to C8. If I remove the 2nd Sort Key (sort by role) it is almost as I want it to be, but then the As are all mixed together.
Is there a Custom Order I can set that will solve this?
I hope I've explained myself well enough and I'm hoping someone can help me out.
Thanks
Liam