percentages

M

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
 
D

David Biddulph

Mark Scott said:
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
Click to expand...

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)
 
Top