Restarting a count

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.

Thanks for your response. Unfortunately this did not work. The result was:

Expected: 6,6,5,4,3,2,1...etc

Result: 1,6,3,2,1,6,5,4,3,2,1...etc

I'm filling down also, but the principle is the same.

Thanks for your help.

Thanks for your example and continued assistance. I created a basic sheet (Sheet2) to show the problem.

Reset Counter TMS.xlsx

Cheers