Hi Leo,
In answer to:
Would
Range("p2").Value = temp2 - temp
by any chance be
Range("p2").Value = temp - temp2

Yes sorry that was a typo.

As for your second query, I need to explain that the sequence of numbers
should never increase so I will change the sequence you wrote for one
actually in my data set and the required result
For the numbers:

J2: 1050

M2:Q2 = 700,700,350,350,0
The resulting sequence in M2:Q2 would be
350,0,350,0,350

I thinking that I can use a test for zero to stop the loop.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!