+ Reply to Thread
Results 1 to 9 of 9

Sorting data using 2 columns

  1. 04-29-2015, 07:29 AM #1
    Granddad
    Granddad is offline
    Registered User
    Join Date
    08-22-2011
    Location
    Ireland
    MS-Off Ver
    Excel 2003
    Posts
    9

    Sorting data using 2 columns

    Hi All, Great to know you are there.
    I'm sorting data by two columns, first Estate and then by House No. However I find that the house numbers don't sort correctly. i.e in the various sorted Estate groupings there's an occasional house number out of order or mis-sorted. e.g. it would be sorted 1, 2, 3, 5, 8, 15, 17, 24, 35, 6. Six being the problem.
    I've checked for extra spaces before or after and that looks OK. Any suggestions.
    The information I'm sorting is initially filtered on the Estate column to hide blank cells and I'm using Excel 2003
    I'm not sure if I should start a new thread for this but house no's with letters e.g 125a sorts to the bottom of the numbers.

    Thank you for any help offered.
    Reply With QuoteRegister To Reply
  2. 04-29-2015, 07:33 AM #2
    Glenn Kennedy
    Glenn Kennedy is offline
    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,064

    Re: Sorting data using 2 columns

    Please attach a sample workbook. Make sure there is enough data to demonstrate your need. Make sure your desired results are shown, mock them up manually if necessary. Remember to remove ALL confidential information first!!!

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    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
    Reply With QuoteRegister To Reply
  3. 04-29-2015, 07:33 AM #3
    LokeshKumar
    LokeshKumar is offline
    Forum Contributor LokeshKumar's Avatar
    Join Date
    03-31-2015
    Location
    India
    MS-Off Ver
    All, mostly 2010 now..
    Posts
    471

    Re: Sorting data using 2 columns

    can you upload the sample workbook???
    Lokesh Kumar
    Stay Hungry.. Stay Foolish..
    _________________________________________________________
    Please Click STAR to Add Reputation if my/someone's answer helped!
    Reply With QuoteRegister To Reply
  4. 04-29-2015, 07:34 AM #4
    Nisha Dhawan
    Nisha Dhawan is offline
    Valued Forum Contributor
    Join Date
    05-07-2014
    Location
    India
    MS-Off Ver
    MS Office 365
    Posts
    313

    Re: Sorting data using 2 columns

    Hi Grandded,

    If you see the numbers again, you will see that the numbers are not in the equal digit format due to which when you are trying to sort them, the six is coming after 35 instead of coming after 5.

    EDIT - The reason being they are coming in this order because It is sorting from 1st digit, and 6 comes after three - 35.

    If you make all the numbers in equal digit e.g. 001,002,003,005,006,008 etc. then there will be no sorting problem.
    Last edited by Nisha Dhawan; 04-29-2015 at 07:37 AM.
    Thanks
    Nisha Dhawan


    If you like my answer please click on * Add Reputation
    "If you can dream it, You can do it "
    Reply With QuoteRegister To Reply
  5. 04-29-2015, 07:50 AM #5
    Granddad
    Granddad is offline
    Registered User
    Join Date
    08-22-2011
    Location
    Ireland
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: Sorting data using 2 columns

    Thank you all, Glenn Kennedy, LokeshKumar, Nisha Dhawan, for such a speedy response.
    I'll send a sample sheet shortly.
    Re 001, 002 etc. I also use this workbook for an addressed envelope mail merge so that wouldn't look good.
    I forgot to mention also the information being sorted in the columns mentioned is taken from another sheet in the same workbook using the function ( =box_identity!E1464)
    Reply With QuoteRegister To Reply
  6. 04-29-2015, 08:08 AM #6
    Granddad
    Granddad is offline
    Registered User
    Join Date
    08-22-2011
    Location
    Ireland
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: Sorting data using 2 columns

    Hi All, I've taken a closer look at the data in the source page and discovered extra spaces in the Estate column info which was causing the problem. I was looking for the problem the numbers column. Sincere apologies if I wasted your time. However it was the exercise of asking that helped concentrate.
    Thanks again.
    Reply With QuoteRegister To Reply
  7. 04-29-2015, 08:22 AM #7
    Glenn Kennedy
    Glenn Kennedy is offline
    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,064

    Re: Sorting data using 2 columns

    That sort of thing usually is extra spaces... Glad you got sorted!!
    Reply With QuoteRegister To Reply
  8. 04-29-2015, 11:27 AM #8
    LokeshKumar
    LokeshKumar is offline
    Forum Contributor LokeshKumar's Avatar
    Join Date
    03-31-2015
    Location
    India
    MS-Off Ver
    All, mostly 2010 now..
    Posts
    471

    Re: Sorting data using 2 columns

    Quote Originally Posted by Granddad View Post
    Hi All, I've taken a closer look at the data in the source page and discovered extra spaces in the Estate column info which was causing the problem. I was looking for the problem the numbers column. Sincere apologies if I wasted your time. However it was the exercise of asking that helped concentrate.
    Thanks again.
    It is great that you have sorted out....but if you had uploaded the workbook...then you would have got the solution earlier.....
    It saves others time as well....
    Reply With QuoteRegister To Reply
  9. 04-30-2015, 12:03 AM #9
    Nisha Dhawan
    Nisha Dhawan is offline
    Valued Forum Contributor
    Join Date
    05-07-2014
    Location
    India
    MS-Off Ver
    MS Office 365
    Posts
    313

    Re: Sorting data using 2 columns

    Hi Granddad,

    Thanks for adding feedback and reputation.

    If your problem has been resolved, please mark this thread as SOLVED.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Data Analysis: Comparing 3 columns, sorting, removing unique values, display data
    By kmills2626 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-14-2013, 07:27 AM
  2. VBA Codes for sorting columns by more than 3 criteria and for verifying sorting on columns
    By alchavar in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-15-2013, 09:18 AM
  3. Sorting data in the right columns
    By excelfrogs in forum Excel General
    Replies: 0
    Last Post: 04-12-2012, 05:21 PM
  4. Help with sorting data-columns H-M and weights to columns N-S.
    By Lutrine in forum Excel General
    Replies: 1
    Last Post: 07-03-2011, 05:10 AM
  5. [SOLVED] Sorting two columns of data
    By Max in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1