Sort Lottery #'s listed left to right

rbraxton

Board Regular
Joined
Oct 17, 2002
Messages
197
I downloaded some (past winning) lotto #'s, and they are all listed left to right in about 1,000 rows.
But, the #'s are listed in order they were picked, instead of low-to-highest.
I now how to sort one row at a time, but that would take to long for the whole sheet.
(I'm not sure how to do the macro for it.)
Any ideas how I can sort all these rows faster?
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

Mark W.

MrExcel MVP
Joined
Feb 10, 2002
Messages
11,654
Each row bears a single, array formula that returns 6 sorted values...
Book1
ABCDEFGHIJKLMNO
1334330382912122930333843
2152425364143152425364143
3413643112123112123364143
41050433582881028354350
5222336274812122223273648
6535214241838141824385253
7352133512322212223333551
851424587157815424551
93745486421161137424548
10401046511527101527404651
11
Sheet1


Note: Array formulas must be entered using the Control+Shift+Enter key combination. The outermost braces, { }, are not entered by you -- they're supplied by Excel in recognition of a properly entered array formula. For more on array formulas see the Excel Help topic for "About array formulas and how to enter them".
 

rbraxton

Board Regular
Joined
Oct 17, 2002
Messages
197
Thanks Mark; I'm learning as I go though, and still haven't quite entered my formula correctly, I think.

I put in an array for the range of cells, but I'm only getting results (in every row) for the first row's #'s.

12 29 30 33 38 43
12 29 30 33 38 43
12 29 30 33 38 43

What mistake have I made?
 

Mark W.

MrExcel MVP
Joined
Feb 10, 2002
Messages
11,654
1. Select H1:M1
2. Enter =SMALL(A1:F1,{1,2,3,4,5,6}) on the formula bar.
3. Simultaneously press Control+Shift+Enter
4. Drag selection downward.
 

rbraxton

Board Regular
Joined
Oct 17, 2002
Messages
197
Of course!
Thanks!!!

(once again, I was caught trying to do too much too fast...lol)
 

Forum statistics

Threads
1,144,328
Messages
5,723,730
Members
422,512
Latest member
MHau5

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top