+ Reply to Thread
Results 1 to 2 of 2

Sorting from smallest to biggest problem

Hybrid View

Beginner101 Sorting from smallest to... 02-13-2025, 05:31 AM
AliGW Re: Sorting from smallest to... 02-13-2025, 05:42 AM
  1. #1
    Registered User
    Join Date
    02-13-2025
    Location
    Slovenia
    MS-Off Ver
    2021
    Posts
    1

    Sorting from smallest to biggest problem

    I have an issue regarding sorting from smallest number (value) to biggest in my Excel 2021.

    Sample of my data:
    1070/105
    1070/11
    1070/3
    1070/205
    1070/206
    1070/207
    1070/120
    1070/50
    1070/2
    1070/4

    I think the problem lies in the slash symbol (/) as Excel does not read it correctly. I tired to change all slashes into decimal separators, to change the data to a decimal number. Then I have sorted them from smallest to biggest and then again changed the symbol back to slash. That did not help.

    Is there an easy solution to it, or do I need to use some kind of custom VBA to solve that?

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2505 (Windows 11 Home 24H2 64-bit)
    Posts
    91,303

    Re: Sorting from smallest to biggest problem

    Welcome to the forum.

    The issue is that Excel sees these entries as TEXT and will therefore sort them alphabetically. You would need to change them to this to make it work:

    1070/105
    1070/011
    1070/003
    1070/205
    1070/206
    1070/207
    1070/120
    1070/050
    1070/002
    1070/004

    There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.

    A good sample workbook has just 10-20 rows of representative data that has been desensitised. The sample layout accurately matches that of your real data. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Help Showing biggest and smallest values from a range as a name
    By FTC in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-11-2023, 05:23 PM
  2. [SOLVED] Ordering numbers from smallest to biggest in a row (from left to right)
    By aaaaa34 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-25-2018, 10:59 AM
  3. Finding Variable With Smallest Shift and Biggest Capacity
    By Phorkys in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-03-2016, 11:12 AM
  4. Positive and neg % biggest to smallest
    By TreeLife in forum Excel General
    Replies: 6
    Last Post: 02-27-2016, 02:38 PM
  5. The last 11 Numbers in column / substract the smallest and biggest / do the average
    By titoine69 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-08-2015, 11:26 AM
  6. Nearest smallest and biggest number VBA issue
    By gan_xl in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-25-2014, 11:18 AM
  7. [SOLVED] Sorting out data in order to have bar graphs from biggest to smallest
    By bobby.bobby in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-08-2013, 06:50 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1