T
tepic
Newby here so bare with me on the description..
I have an Excel 2000 spreadsheet with four worksheets.
On three worksheets I have the results of race meetings, each class on
a seperate worksheet. These are ordered currently by the competitors
number with the finishing positions for each race put in and a point
system working out the total for each competitor.
On the other worksheet I would like to put the class positions in
order, and then an overall championship position combining the scores
from all the classes.
I currently use the rank function to get out the position of each
competitor on the class worksheets, but I have not found a way that
will display these positions (in order 1st,2nd,3rd etc.) on another
worksheet in order automatically. Does anyone know how to do this
without creating a macro in VBA?
Thanks in advance for the help,
Tepic
I have an Excel 2000 spreadsheet with four worksheets.
On three worksheets I have the results of race meetings, each class on
a seperate worksheet. These are ordered currently by the competitors
number with the finishing positions for each race put in and a point
system working out the total for each competitor.
On the other worksheet I would like to put the class positions in
order, and then an overall championship position combining the scores
from all the classes.
I currently use the rank function to get out the position of each
competitor on the class worksheets, but I have not found a way that
will display these positions (in order 1st,2nd,3rd etc.) on another
worksheet in order automatically. Does anyone know how to do this
without creating a macro in VBA?
Thanks in advance for the help,
Tepic