Sorry, Puzzled. Totally misread your question (through the required
output spacing gaps automatically being trimmed when you posted).

Sandy's got it. Perhaps you may also need to adjust that formula to
allow for a 100 series being jumped (e.g going directly from 385 to
507, missing the 400 series), being re-entered (e.g. through a decrease
from 402 to 399) or the first entry being in the 100's.

On these assumptions, and with your label in A5, B5 being empty and
first figure in C5, my formula in column C should have read:
=IF(INT(c5/100)=INT(B5/100),"",(INT(C5/100)-INT(B5/100))*20)

Or you can adjust Sandy's Floor formula similarly.
=IF(FLOOR(C5,100)=FLOOR(B5,100),"",(FLOOR(C5,100)-FLOOR(B5,100))*0.2)

Then copy the formula to the right.


--
John James
------------------------------------------------------------------------
John James's Profile: http://www.excelforum.com/member.php...o&userid=32690
View this thread: http://www.excelforum.com/showthread...hreadid=528449