# Thread: Lotto database of 5005 rows needs sorting

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. 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. 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.

4. 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. 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.

6. …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.

7. p45cal, thanks so much! That's exactly what I what I want!
Denise

8. 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. Thanks Bob. Which formula are you referring to?

Page 2 of 2 First 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
•