o.k. yes I see your conundrum.

There are other ways to do it, but just quickly in column B enter =MAX(A:A) and copy it down as far as you want.

In cell C1 type =IF(A1=B1,100,(A1/B1*100)) and copy it down the page.

__________________
RaceCensus - powerful system testing software.
Now with over 426,000 Metropolitan, Provincial and Country races!
http://www.propun.com.au/horse_raci...ng_systems.html
*RaceCensus now updated to 31/10/2025
Video overview of RaceCensus here:
http://www.youtube.com/watch?v=W821YP_b0Pg