Dr Ron
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. |
The thread went to the relevant forum - the General Forum.
Moderator. |
Thanks CP
|
All times are GMT +10. The time now is 11:50 PM. |
Powered by: vBulletin Version 3.0.3
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.