In my job, every day I receive excel file with 2 columns (A1, B2) of unsorted data. For example:
A1 B2 DD E AA Y CC C AA W CC B CE I AA P CE C DD Y
What I wanted to do is to sort it first by 2 letters of cell in first column and then by text in second column. Like this:
A1 B2 AA P AA W AA Y CC B CC C CE C CE I DD E DD Y
As you can see, text in B2 is sorted from A to Z, but within groups from A1 (AA, CC, CE, DD)
To be honest, I'm not very familiar with Excel. This kind of multiconditional sorting I need to create in some macro, vba?
I tried to use multisort option (sort by Column A, Sort on Values, order A to Z, then sort by Column B, Sort on Values, order A to Z) but it's not working how I wanted. Can somebody help me with this problem?