Nelson78
Well-known Member
- Joined
- Sep 11, 2017
- Messages
- 526
- Office Version
- 2007
Hello everybody.
I'm struggling in order to build a code for an unconventional alphabetical order.
Consider I have the record from row 2 to n in a randomic order.
In the image the requested outcome.
https://imgur.com/a/j0Jv1Cs
The principles:
1) Surname's sellers - yellow rows - in alphabetical order;
2) then, for each seller, the related white rows (see the code in column B) in alphabetical order for column A.
I think it is not possible to figure it out with the conventional Excel settings.
Any idea?
Thank's for the support.
I'm struggling in order to build a code for an unconventional alphabetical order.
Consider I have the record from row 2 to n in a randomic order.
In the image the requested outcome.
https://imgur.com/a/j0Jv1Cs
The principles:
1) Surname's sellers - yellow rows - in alphabetical order;
2) then, for each seller, the related white rows (see the code in column B) in alphabetical order for column A.
I think it is not possible to figure it out with the conventional Excel settings.
Any idea?
Thank's for the support.
Last edited: