13th February 2005, 02:09 PM
|
|
Member
|
|
Join Date: Jan 1970
Posts: 4,426
|
|
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.
|