Ardus,

With your formula changed to =MAX(20-MAX(A$1:A$500)+A1,0)

This appears to work thank you, also thanks to Andy for his help.

Best regards,

Eamon
"Ardus Petus" wrote in message
...
In B1:
=MAX(20-MAX(A$1:A$500)+A1;0)

then copy down

HTH
--
AP

"Eamon" a écrit dans le message de
...
Anyone have a formula that will do this please...



In Column A1:A500 I have numbers such as.

100

85

38

47

95

101

In B1:B500 I would like to have a formula that will return 20 for the
Highest number in A1:500 such as.

101=20

100=19

95=14

85=4

47=0

38=0



Thank you,



Eamon