Reply #1

CountingMan — Sun, 20 Aug 2017 18:02:57 GMT

I use the following formula to sort drawings from lowest to hugest from left to right:

Highlight the cells where you want the results returned then type in the following formula I. The far left cell:

=small (array, {1,2,3,4,5}) and hit Ctrl, Shift, and Enter at the same time

vba to Sort past lottery results smallest to largest

timmsy — Mon, 14 Aug 2017 09:25:16 GMT

This is a vba i used to Sort past lottery results smallest to largest , this example is for 10 numbers starting at B1 to k1, you can change it to suit your lotto or Keno just change the range

Sub sort_results_ascending() 'from top to bottom sort left to right on data page

Sheets( data ).Select

Application.Calculation = xlCalculationManual

Range( B1:k1 ).Select ' first draw (chage to suit your lottery)

Do While ActiveCell.Value 0

Selection.Offset(1, 0).Select

Sel... [ More ]