Hi all excel buffs.

I have a row of data that has been calculated to produce the following series of numbers.

6,5,4,3,2,1,6,5,4,3,2,1 (That is: [6 to 1], [6 to 1])

This dataset has been corrected to produce the following series

2,1,4,3,2,1,6,5,4,3,2,1 (that is: [2,1] then [4-1] then [6 to 1])

In this problem, the method for calculating the dataset doesn't restart from 6. It assumes that 2,1,4,3,2,1 has produced the required 6 count.

What I need is for a method or function to restart the number sequence from 6 following the correction,

That is [2 to 1], [6 to 1]...etc)


Cheers for any help.