percentages
 

I currently have a list of times which have next to them a percentage
compared with the first time. If the time has a percentage which is higher
than 100, I want Excel to make this the new base time for percentages and
adjust the old values accordingly ie:

100
90 90%
95 95%
105 THIS BECOMES THE NEW 100% benchmark

percentages
 

Mark,

If you want the existing percentages to change the try:

=A1/MAX(A:A)

formatted as percentage

--
HTH

Sandy
In Perth, the ancient capital of Scotland


with @tiscali.co.uk


"Mark Scott" <mark - scott @ blueyonder . co . uk wrote in message
. uk...
I currently have a list of times which have next to them a percentage
compared with the first time. If the time has a percentage which is
higher than 100, I want Excel to make this the new base time for
percentages and adjust the old values accordingly ie:

100
90 90%
95 95%
105 THIS BECOMES THE NEW 100% benchmark

percentages
 

"Mark Scott" <mark - scott @ blueyonder . co . uk wrote in message
. uk...
I currently have a list of times which have next to them a percentage
compared with the first time. If the time has a percentage which is
higher than 100, I want Excel to make this the new base time for
percentages and adjust the old values accordingly ie:

100
90 90%
95 95%
105 THIS BECOMES THE NEW 100% benchmark

If your left hand column goes from A1 downwards, use this in B2
=A2/MAX(A$1:A2) and copy down, if you want answers like your example.

In your words, however, you say "adjust the old values accordingly", so if
you want to adjust your 90% & 95% to account for the 105, then use
=A2/MAX(A:A)
--
David Biddulph

percentages
 

Wonderful! Thanks Sandy

"Sandy Mann" wrote in message
...
Mark,

If you want the existing percentages to change the try:

=A1/MAX(A:A)

formatted as percentage

--
HTH

Sandy
In Perth, the ancient capital of Scotland


with @tiscali.co.uk


"Mark Scott" <mark - scott @ blueyonder . co . uk wrote in message
. uk...
I currently have a list of times which have next to them a percentage
compared with the first time. If the time has a percentage which is
higher than 100, I want Excel to make this the new base time for
percentages and adjust the old values accordingly ie:

100
90 90%
95 95%
105 THIS BECOMES THE NEW 100% benchmark