Custom Sort - Use Last Letter

nniedzielski

Active Member
Joined
Jan 8, 2016
Messages
492
I have a list of data that I am cleaning. It has 5 columns.
I need the following to happen to get the data in the orderthat I need it in. I have tried everythingI can think of, but I keep ending up with issues.
Column D is a combination of 2 letters, i.e. XA, GS,RY. It will always be two. I need to first sort this list so that everycell that ends with S is listed first. So, the list would be like BS, GS, RS, TS, AB, AD, GA, RR, etc. I can dothis with a filter, but I don’t want to filter, I just want to arrange.
Then I want to custom sort by Column D with the “Ends with S”first, then by Column A.

Can anyone help me navigate this?
Thanks,
 

Some videos you may like

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

kweaver

Well-known Member
Joined
May 8, 2018
Messages
1,039
Office Version
365, 2010
Would you consider a helper column (e.g., E) that contains the last letter from the D column?

If so, fill this down:

Code:
=RIGHT(D1,1)
Then do your double sort on E and then A.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,018
Messages
5,466,066
Members
406,462
Latest member
I10V3xl

This Week's Hot Topics

Top