Quote:
Originally Posted by Claus Busch
Hi Jay,
Am Wed, 10 Apr 2013 15:18:10 +0000 schrieb Jay07:
Column A Column B
1 200 100%
2 150 75%
3 100 50%
4 50 25%
5 0 0%
in B2:
=A2/$A$1 and format as % and copy down
Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
|
Thanks Claus.
With a small amendment I got it to work in my spread sheet.
In B1:
=A1/MAX($A$1:$A$5)
Shows the highest number as 100%, the lowest as 0% and the rest fall as they may.