Yet more on Excel

[xptdriver]

Gday Excel Experts

this one isn't that hard I don't think... I have looked all around the program and in help and can't find an answer, so I am assuming the answer is "no"..

I am using Office Pro for XP.. and am wondering about the sort function.. When I go to sort data I only get 3 drop downs in the sort column section., is it possoble to get more columns that I can sort .. and if so how do i do it..

Any help would be appreciated

[Shaun]

No....you can only use that section and sort 3 options....but it depends what you nees to sort....if you explain what you need you may be able to use another functions to get your results

[xptdriver]

Gday Shaun

Thanx for the reply...

The header rows I wish to sort are...

Days
Average Prizemoney
Rating Figure
Stakes
Win %
Place %

Also i was wondering is it possible to a apply a weighting to the sort?

[Chrome Prince]

Hi xptdriver,

Yes it is possible to apply a weighting to the sort or priority.

Assuming your fields are:
Date
Track
Horse
Race
TAB#
Days
Average Prizemoney
Rating Figure
Stakes
Win %
Place %

Now let's say you just want them in race and TAB number order as per the formguide.

Data/Sort by TAB# Ascending

Then Data/Sort by Date (Ascending), Track (Ascending), Race (Ascending).

Think of it as you wanted them in TAB order, so you do this first.

If you wanted them in Rating figure order (Highest first)...

Data/Sort by Rating Figure (Descending)

Then Data/Sort by Date (Ascending), Track (Ascending), Race (Ascending).
-----------------------------------------------------------------------

Now here's a little ranking trick I use to give the rating a rank.

First sort by ranking as above.

Now in a new column enter this formula:

=IF(B1&C1<>B2&C2,1,L1+1)

Assuming the track is in column B, the Race number is in column C and this formula is going in column L.
Now copy this and paste it all the way down column L.

Copy(column L) & paste special (Values).

You now have the rankings.

Regards.

[La Mer]

Hi xptdriver,
Now here's a little ranking trick I use to give the rating a rank.

First sort by ranking as above.

Now in a new column enter this formula:

=IF(B1&C1<>B2&C2,1,L1+1)

Assuming the track is in column B, the Race number is in column C and this formula is going in column L.
Now copy this and paste it all the way down column L.

Copy(column L) & paste special (Values).

You now have the rankings. Regards.

Chrome, any reason why you just wouldn't use the rank worksheet function?

The following is an example:

=IF(A1="","",RANK(A1,A$1:A$26))

[Chrome Prince]

Chrome, any reason why you just wouldn't use the rank worksheet function?

The following is an example:

=IF(A1="","",RANK(A1,A$1:A$26))

Yes La Mer, I could use the rank function,but I export a whole Saturday's racing to the one spreadsheet and find my way easier as it only takes one simple formula to get what I want all the way down the page.

[xptdriver]

Hi xptdriver,

Yes it is possible to apply a weighting to the sort or priority.

Assuming your fields are:


(snipped)

Gday Chrome

thanks for your help mate... much appreciated..