|
|
To advertise on these forums, e-mail us. |
|
|
Thread Tools | Search this Thread | Display Modes |
#1
|
|||
|
|||
Yet more on Excel
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 |
#2
|
|||
|
|||
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
|
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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.
__________________
RaceCensus - powerful system testing software. Now with over 412,000 Metropolitan, Provincial and Country races! http://www.propun.com.au/horse_raci...ng_systems.html *RaceCensus now updated to 31/12/2024 Video overview of RaceCensus here: http://www.youtube.com/watch?v=W821YP_b0Pg |
#5
|
|||
|
|||
Quote:
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)) |
#6
|
|||
|
|||
Quote:
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.
__________________
RaceCensus - powerful system testing software. Now with over 412,000 Metropolitan, Provincial and Country races! http://www.propun.com.au/horse_raci...ng_systems.html *RaceCensus now updated to 31/12/2024 Video overview of RaceCensus here: http://www.youtube.com/watch?v=W821YP_b0Pg |
#7
|
|||
|
|||
Quote:
(snipped) Gday Chrome thanks for your help mate... much appreciated.. |
Thread Tools | Search this Thread |
Display Modes | |
|
|