Results 1 to 3 of 3

Thread: Custom Sort - Use Last Letter
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Jan 2016
    Posts
    320
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Custom Sort - Use Last Letter

    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,

  2. #2
    Board Regular kweaver's Avatar
    Join Date
    May 2018
    Location
    La Jolla, CA
    Posts
    403
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Custom Sort - Use Last Letter

    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.

  3. #3
    Board Regular
    Join Date
    Jan 2016
    Posts
    320
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Custom Sort - Use Last Letter

    you're a genius,

    thank you

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •