Page 2 of 2 FirstFirst 1 2
Results 11 to 19 of 19

Thread: Lotto database of 5005 rows needs sorting

  1. #11
    Magician NoS's Avatar
    Join Date
    Jan 2013
    Location
    British Columbia
    Posts
    788
    Articles
    0
    Excel Version
    Excel 2010


    Register for a FREE account, and/
    or Log in to avoid these ads!

    Actually those are 6 columns of strings that look like numbers.
    Ali's second formula is an array formula that needs confirmed in H1 with Shift+Ctrl+Enter not just Enter.
    Then can be dragged over to M and down.

  2. #12
    Seeker excelnot's Avatar
    Join Date
    Jan 2020
    Posts
    12
    Articles
    0
    Excel Version
    2007
    Thanks, NoS.
    I meant to say that this 'workbook' isn't mine, so I have no idea how to alter it. And I'm no Excel expert.
    I found it online while looking something that can generate 6-number combos from up to 15 source numbers.
    The workbook does that, but I can't do the next step - sorting each line low to high.
    I think the project was aimed at sorting words rather than numbers.
    Could the formula be changed to do only numbers?
    Thanks,
    Denise :-)

  3. #13
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,364
    Articles
    0
    Excel Version
    Office 365 Subscription
    Ali, if you go to Sheet 2, there are 6 columns of numbers.
    Yes, but you have not showed what you have tried - there isn't an attempted formula anywhere.

    The columns on sheet 2 contain text and are already in ascending order as far as I can see. However, as I stated before, my second formula would sort them and convert them into numbers if entered in H1 and drag copied across and down (note what NoS said in post #11 about entering the formula). In the attached I have done this for a few lines.

    If this isn't what you want, then I am sorry, but I am completely lost.
    Attached Files Attached Files
    Ali
    Enthusiastic self-taught user of MS Excel!

  4. #14
    Seeker excelnot's Avatar
    Join Date
    Jan 2020
    Posts
    12
    Articles
    0
    Excel Version
    2007
    Sorry, did I say ascending order for columns? It's rows I want to sort, ascending, so the lowest number in each row is in column A.
    And no, there aren't any formulas on Sheet 2, because I don't know how to do them. Which is why I asked the question in my first post.
    As I said to NoS, it's not my workbook, I just found it online.
    All I did was follow the instructions in the text boxes and the 6 columns of data appear on Sheet 2.
    Thanks,
    Denise.

  5. #15
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,364
    Articles
    0
    Excel Version
    Office 365 Subscription
    OK - so in the sample file, the text that appears in columns A to F is already in ascending order. Did you look at the attachment to post #11? Does it do what you want? If not, what is it that you need? Is it the conversion of the text values in columns A to F into number values? Please try to be specific with your answer. I realise you are getting frustrated, but we are trying to help.
    Ali
    Enthusiastic self-taught user of MS Excel!

  6. #16
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,677
    Articles
    0
    Excel Version
    365
    …or a short macro or two. See attached Sheet2 buttons.
    It takes a few seconds.
    I've converted the numbers-as-text to numbers, but it's not necessary.
    Attached Files Attached Files

  7. #17
    Seeker excelnot's Avatar
    Join Date
    Jan 2020
    Posts
    12
    Articles
    0
    Excel Version
    2007
    p45cal, thanks so much! That's exactly what I what I want!
    Denise

  8. #18
    Acolyte bobjglover@gmail.com's Avatar
    Join Date
    Aug 2015
    Posts
    54
    Articles
    0
    Excel Version
    1901
    The formula will work if you just adjust the cell format in Sheet 2 from General to Number? Are you hoping the formula would do that for you before it sorts?

  9. #19
    Seeker excelnot's Avatar
    Join Date
    Jan 2020
    Posts
    12
    Articles
    0
    Excel Version
    2007
    Thanks Bob. Which formula are you referring to?

Page 2 of 2 FirstFirst 1 2

Posting Permissions

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