Hi!

I need help with the PERCENTRANK excel function for my data set....

I have a data set of several physical abilities tasks, such as pushups,
situps, pullups,
running a certain distance, etc. I have calculated all of the percentranks
for each individual's score on each task, but I cannot figure out how to get
the percentrank for the timed tests. For example, the 100 meter run, as a
timed task, the individual with the fasted time (lowest number in seconds)
should show up as 100% for the percentrank score, but the opposite is
happening. Excel is giving the higher percents to the individual's with a
higher times, because excel is equating the larger number in the data set to
a better score, thus a higher percent.

Is there a function to invert or reverse code the timed data scores?

Thanks for all of your help!