+ Reply to Thread
Results 1 to 3 of 3

data - sort by numbers

  1. #1
    Registered User
    Join Date
    05-12-2022
    Location
    toronto, ontario
    MS-Off Ver
    2010
    Posts
    2

    data - sort by numbers

    I have a table and one column has the following order:
    3
    3.1
    3.1.1
    3.1.2
    3.2
    3.2.1
    3.2.2
    4
    etc
    but new rows will be added so each number may have different ranges ie. 3.1.1 to 3.1.15.

    people will go going in and sorting by different columns. but once they sort on the number columns i'd like the format to be the same as above. is there a way to do this?

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,023

    Re: data - sort by numbers

    It's easy if you use 3.01.01 instead of 3.1.1. Can that work for you?
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Registered User
    Join Date
    05-12-2022
    Location
    toronto, ontario
    MS-Off Ver
    2010
    Posts
    2

    Re: data - sort by numbers

    it sorts like this:
    3.1
    3.2
    3.01.02
    3.01.03


    But needs to be:
    3.1
    3.01.02
    3.01.03
    3.2

+ 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. Replies: 4
    Last Post: 10-20-2020, 04:15 PM
  2. [SOLVED] VBA to Sort Data and exclude the negative numbers with respect to time during averaging
    By vnzerem in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-18-2013, 12:00 PM
  3. How can I data sort more than 1 row of numbers numerical order
    By Larbec in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-13-2013, 12:46 AM
  4. [SOLVED] How to merge a numbers from 3 cells, eliminate repetitive numbers, and sort such numbers?
    By david gonzalez in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-22-2012, 11:59 AM
  5. Replies: 2
    Last Post: 04-03-2006, 03:40 PM
  6. How can I sort data in sequence by odd/even numbers
    By TxBlackJack in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-19-2006, 01:15 PM
  7. [SOLVED] How can I sort a group of numbers automatically as data is entere
    By Adrew in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-18-2005, 09:00 PM

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