percentages

[Mark Scott]

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

 

[Sandy Mann]

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

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk

 

[David Biddulph]

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)

 

[Mark Scott]

Wonderful! Thanks Sandy

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

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk