Custom Sort - Use Last Letter

nniedzielski

Well-known Member
Joined
Jan 8, 2016
Messages
590
Office Version
  1. 2019
Platform
  1. Windows
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,
 

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result
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.
 
Upvote 0

Forum statistics

Threads
1,213,510
Messages
6,114,034
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top