Where did the excel post go????

Delete formula in column B altogether and just paste this in instead.

=IF(A1=MAX(A:A),(MAX(A:A)/MAX(A:A))*100,(A1/MAX(A:A)*100))

Saves an extra column.

Oh I see they've moved it to a General forum category - sorry.

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