
03 Nov 2019  #1 

Excel spreadsheet of Lotto results  formula question
I'm trying to query a spreadsheet of 100 Lotto draws.
I want to reorder all rows of 6 numbers from drawn order to lowhigh numeric order. Here are a few typical ball sequences in the order the balls emerged: a) 40102522416 b) 34177393130 c) 2434025711 Instead, I'd like the sequences to look like this: a) 41016222540 b) 71730313439 c) 3711242540 Is this possible? Thanks. 
My System Specs 
. 

03 Nov 2019  #2 

Sort data in Excel Rows
Columns are easier but you listed as rows or How to SORT in Excel (by Rows, Columns, Colors, Dates ... Enjoy! Bill GCF_Learn_Free.org 
My System Specs 
03 Nov 2019  #3 

Thanks, but I didn't really want to learn Excel in depth  all I want to do is what I described above.

My System Specs 
. 

04 Nov 2019  #4 

Hi teckneeculler,
I'm trying to query a spreadsheet of 100 Lotto draws.
I want to reorder all rows of 6 numbers from drawn order to lowhigh numeric order. Here are a few typical ball sequences in the order the balls emerged: a) 40102522416 b) 34177393130 c) 2434025711 Instead, I'd like the sequences to look like this: a) 41016222540 b) 71730313439 c) 3711242540 Is this possible? It depends on how complex you want to make this! The easiest solution is to perform TextToColums to get rid of the "" and have each number in its own cell. Lets assume that your Lotto numbers are in cells A1:F?, put these formulas in cells H1:M1 and copy down . . . Code:
=IF($A1=0,"",SMALL($A1:$F1,1)) =IF($A1=0,"",SMALL($A1:$F1,2)) =IF($A1=0,"",SMALL($A1:$F1,3)) =IF($A1=0,"",SMALL($A1:$F1,4)) =IF($A1=0,"",SMALL($A1:$F1,5)) =IF($A1=0,"",SMALL($A1:$F1,6)) 
My System Specs 
04 Nov 2019  #5 

Hi teckneeculler,
If you wanted the "" between the numbers, you could put this formula in cell O1 and copy down . . . Code:
=IF($A1=0,"",SMALL($A1:$F1,1)&""&SMALL($A1:$F1,2)&""&SMALL($A1:$F1,3)&""&SMALL($A1:$F1,4)&""&SMALL($A1:$F1,5)&""&SMALL($A1:$F1,6)) 
My System Specs 
06 Nov 2019  #6 

Paul, thanks very much.
Re the dashes, there are none: the numbers are in cells, as in a regular spreadsheet. I've attached a section of the spreadsheet. 
My System Specs 
06 Nov 2019  #7 

Hi teckneeculler,
In cells J2:O2 put numbers one to six in the respective cells. In cell J3 enter . . . Code:
=IF($C3=0,"",SMALL($C3:$H3,J$2)) I hope this helps! 
My System Specs 
. 
06 Nov 2019  #8 


My System Specs 
06 Nov 2019  #9 

Sorting a Row
Sorting in a Row.docx To sort by a row, follow these steps:
Help? What you asked for? YES YES Bill 
My System Specs 
08 Nov 2019  #10 

Snick, thanks but I'm using Excel 2003. The GUI is quite different to later versions  much simpler, in fact, which I prefer.

My System Specs 
Thread Tools  
Similar help and support threads  
Thread  Forum  
Excel 2013  how to keep a formula consisten Hi I am trying to tie one cell into a formula that is being pasted into multiple rows. I know you can use $ to keep the cell consistent but it doesn't seem to be working. So if the value is in c9 and then first row gets c9 then the new row gets c10 etc... I need it to be c9 throughout the... 
Microsoft Office  
Excel Formula Hello Sir, Can you let me know the formula in Excel: I have a table as below: This table, At the column "A,Status" when i Put the word" Completed", it's will automatic put current Date to Column "B, Row 2". But i don't know after that when tomorrow arrived,at the column "B,Row 2",... 
Microsoft Office  
Problem with Excel Spreadsheet I have to admit that I am not proficient in the MS Excel program. I have to fill in a form for a potential employer but the cell is too small to contain all of the informationthe information that I typed in goes "off the page" into neighboring cells that are not part of the form. I can't seem to... 
Microsoft Office  
Excel 2003 sum formula problem I have been entering currency data in Column B in Euros to an EXCEL 2003 s/s and the formula used has added these totals entered in that Column correctly until I reached a total sum of 74364.70 Euros ,this being the sum of entries in Rows B6 to B82 . This was reached with the formula showing as... 
Microsoft Office  
Excel Formula Help please... This is probably very simple and I have got it working but it isn't working how I want it to work. I have created an Excel document to show my monthly payments of a bank loan. I have created 3 columns in the first column is the payment number, in the second column is the amount that the loan... 
Microsoft Office 
Our Sites 
Site Links 
About Us 
Find Us 
Windows 7 Forums is an independent web site and has not been authorized,
sponsored, or otherwise approved by Microsoft Corporation.
"Windows 7" and related materials are trademarks of Microsoft Corp.
© Designer Media Ltd All times are GMT 5. The time now is 18:00. 
