Dr Ron

[Chrome Prince]

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.

[Moderator 3]

The thread went to the relevant forum - the General Forum.
Moderator.

[DR RON]

Thanks CP