Sorting help needed... please!

[Adfy]

Hiya guys,

I need some ppl expert in Excel to help me out.

I have a txt file which contains history draws like below :-

Draw# DrawDate Ball1 Ball2 Ball3 Ball4 Ball5 Ball6 Bonus

Excample :-

09 12 14 20 24 32 11
11 13 22 34 41 42 27
.
.
.

What I really want to know is how to sort each line in Excel.

When I convert them into Excel each numbers get one cell.I tried using Excel, only Excel sort according to column and I got confused how to sort the draws each date to make it ascending like :-

09 11 12 14 20 24 32
11 13 22 27 34 41 42

I would appreciate it if someone would help me on this matter. Sorry, I am not really good in Excel..

 

[thornc]

Adfy,

to do this I usually use Saliu's MDIEditor... under the lotto menu option there is a sort file menu that will allow you to sort lotto file lines! It works!

 

[BushHappy]

Adfy,

Use Covermaster:
For your example, first change Picks from 6 to 7
Then Copy and paste into Covermaster - the lines are automatically sorted.
Then you copy the results from Covermaster and paste them where you want.

 

[Irvin]

If your using MS excel do the following;

Hi lite the row of numbers you want to sort.

Click on "Data" "Sort" "Option" select "sort left to right"

If you have alot of lines todo then best to set up a macro.

 

[johnph77]

Another method:

Records located in cells A1 through F1, bonus ball in G1, target cells can be located anywhere.

In Target Cell H1 enter the formula =LARGE(A1.F1,1)
In Target Cell I1 enter the formula =LARGE(A1.F1,2)
In Target Cell J1 enter the formula =LARGE(A1.F1,3)
In Target Cell K1 enter the formula =LARGE(A1.F1,4)
In Target Cell L1 enter the formula =LARGE(A1.F1,5)
In Target Cell M1 enter the formula =LARGE(A1.F1,6)
In Target Cell N1 enter the formula =G1

You can leave columnar spaces if you so desire. Advantage? Permanent record of how the numbers were drawn, replicable throughout your data range. Disadvantage? Your spreadsheet is that much larger.

 

[Adfy]

Thanks guys... for your guides!!

I will try to create a macro. But... err... how do I do that actually? Sorry... I am not really great at Excel..

I tried with many rows at once Irvin, but it did not work. That's why I need a macro??