Formula error

[ddub25]

I have following formula that works as expected with the table below.

{=MAX(MAX(B2:B12)-IF(ROW(B2:B12)-ROW(B2)+1 >MATCH(MAX(B2:B12),B2:B12,0),B2:B12,9.99999999999999E+307))}

-14.00____-14.00
115.00____101.00
101.50____202.50
163.00____365.50
-81.50_____284.00
14.50_____298.50
-56.00_____42.50
7.00______249.50
29.50_____279.00
-11.00_____268.00
8.50______276.50

However, when I adapt the formula to:

{=MAX(MAX(E28:E327)-IF(ROW(E28:E327)-ROW(E28)+1 >MATCH(MAX(E28:E327),E28:E327,0),E28:E327,9.99999999999999E+307))}

to apply it to another table, it returns "#########....". The table I am applying it to has entries on every cell - no blanks.

Any ideas why?

Dan