Roseam30 wrote:Hi, I would really appreciate some help with my sorting in Excel. I have two columns like the below that needs to be sorted numerically and then alphabetically. example: 49A, 49B, 49c, etc. It can be in Code or the sort function.
Thanks
49 A
51 E
55 D
59 C
63 B
49 C
53 B
49 B
51 A
55 B
59 A
51 B
49 C
I put the above data in cell A1:B13 to resolve your problem. its quite simple. following are the steps:
select the whole data (A1:B13 as per this example)
right click on data\sort\custom sort
the sort window will appear. now sort by column A, Sort on Values and put the Order as Smallest to Largest.
then add another level by clicking on Add Level on top left. Then select column B to sort, sort on values and put the order as A-Z
Clink OK and done.
this is working fine and giving the output as per your need.