Hello People,
I have one (middle) column of numbers and I want to have a running total as a certain pattern appears as shown in the numbers below:
[TABLE="class: cms_table, width: 192"]
<tbody>[TR]
[TD="class: cms_table_xl66, width: 64"]91[/TD]
[TD="class: cms_table_xl66, width: 64"]91[/TD]
[TD="class: cms_table_xl65, width: 64"][/TD]
[/TR]
[TR]
[TD="class: cms_table_xl66, width: 64"]92[/TD]
[TD="class: cms_table_xl65, width: 64"][/TD]
[TD="class: cms_table_xl65, width: 64"][/TD]
[/TR]
[TR]
[TD="class: cms_table_xl66, width: 64"]93[/TD]
[TD="class: cms_table_xl65, width: 64"][/TD]
[TD="class: cms_table_xl65, width: 64"][/TD]
[/TR]
[TR]
[TD="class: cms_table_xl66, width: 64"]94[/TD]
[TD="class: cms_table_xl66, width: 64"]94[/TD]
[TD="class: cms_table_xl66, width: 64"]3[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl66, width: 64"]95[/TD]
[TD="class: cms_table_xl65, width: 64"][/TD]
[TD="class: cms_table_xl65, width: 64"][/TD]
[/TR]
[TR]
[TD="class: cms_table_xl66, width: 64"]96[/TD]
[TD="class: cms_table_xl66, width: 64"]96[/TD]
[TD="class: cms_table_xl66, width: 64"]2[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl66, width: 64"]97[/TD]
[TD="class: cms_table_xl65, width: 64"][/TD]
[TD="class: cms_table_xl65, width: 64"][/TD]
[/TR]
[TR]
[TD="class: cms_table_xl66, width: 64"]98[/TD]
[TD="class: cms_table_xl65, width: 64"][/TD]
[TD="class: cms_table_xl65, width: 64"][/TD]
[/TR]
[TR]
[TD="class: cms_table_xl66, width: 64"]99[/TD]
[TD="class: cms_table_xl66, width: 64"]99[/TD]
[TD="class: cms_table_xl66, width: 64"]3[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl66, width: 64"]100[/TD]
[TD="class: cms_table_xl65, width: 64"][/TD]
[TD="class: cms_table_xl65, width: 64"][/TD]
[/TR]
[TR]
[TD="class: cms_table_xl66, width: 64"]99[/TD]
[TD="class: cms_table_xl66, width: 64"]99[/TD]
[TD="class: cms_table_xl65, width: 64"][/TD]
[/TR]
[TR]
[TD="class: cms_table_xl66, width: 64"]98[/TD]
[TD="class: cms_table_xl65, width: 64"][/TD]
[TD="class: cms_table_xl65, width: 64"][/TD]
[/TR]
[TR]
[TD="class: cms_table_xl66, width: 64"]97[/TD]
[TD="class: cms_table_xl65, width: 64"][/TD]
[TD="class: cms_table_xl65, width: 64"][/TD]
[/TR]
[TR]
[TD="class: cms_table_xl66, width: 64"]96[/TD]
[TD="class: cms_table_xl66, width: 64"]96[/TD]
[TD="class: cms_table_xl66, width: 64"]3[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl66, width: 64"]95[/TD]
[TD="class: cms_table_xl65, width: 64"][/TD]
[TD="class: cms_table_xl65, width: 64"][/TD]
[/TR]
[TR]
[TD="class: cms_table_xl66, width: 64"]96[/TD]
[TD="class: cms_table_xl66, width: 64"]96[/TD]
[TD="class: cms_table_xl65, width: 64"][/TD]
[/TR]
[TR]
[TD="class: cms_table_xl66, width: 64"]97[/TD]
[TD="class: cms_table_xl65, width: 64"][/TD]
[TD="class: cms_table_xl65, width: 64"][/TD]
[/TR]
[TR]
[TD="class: cms_table_xl66, width: 64"]96[/TD]
[TD="class: cms_table_xl66, width: 64"]96[/TD]
[TD="class: cms_table_xl65, width: 64"][/TD]
[/TR]
[TR]
[TD="class: cms_table_xl66, width: 64"]95[/TD]
[TD="class: cms_table_xl65, width: 64"][/TD]
[TD="class: cms_table_xl65, width: 64"][/TD]
[/TR]
[TR]
[TD="class: cms_table_xl66, width: 64"]94[/TD]
[TD="class: cms_table_xl66, width: 64"]94[/TD]
[TD="class: cms_table_xl66, width: 64"]-2[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl65, width: 64"][/TD]
[TD="class: cms_table_xl65, width: 64"][/TD]
[TD="class: cms_table_xl65, width: 64"][/TD]
[/TR]
[TR]
[TD="class: cms_table_xl65, width: 64"][/TD]
[TD="class: cms_table_xl65, width: 64"]Net Total[/TD]
[TD="class: cms_table_xl66, width: 64"]9[/TD]
[/TR]
</tbody>[/TABLE]
You'll notice that 3 is the difference between 91 and 94. 2 is the difference between 96 and 94. 3 is the difference between 99 and 96. 99 repeats twice, so we continue to add 3, which is the difference between 96 and 99. Then, 96 is repeated 3x so we now subtract 2, which is the difference between 94 and 96. If the numbers would continue to decrease one or two at a time, the formula should continue to add the differences until the number is repeated 3 or more odd times. As long as it's repeated once or an even amount of times, it should continue to add the difference instead of subtract it. It should only subtract the difference if the number is repeated 3 or more odd times. I want to be able to copy this down 30k rows again - but don't worry about how many columns it takes to come to a conclusion. My comp can handle it
Hope I was clear. Lemme know if you need any more clarification.
Thanks!
I have one (middle) column of numbers and I want to have a running total as a certain pattern appears as shown in the numbers below:
[TABLE="class: cms_table, width: 192"]
<tbody>[TR]
[TD="class: cms_table_xl66, width: 64"]91[/TD]
[TD="class: cms_table_xl66, width: 64"]91[/TD]
[TD="class: cms_table_xl65, width: 64"][/TD]
[/TR]
[TR]
[TD="class: cms_table_xl66, width: 64"]92[/TD]
[TD="class: cms_table_xl65, width: 64"][/TD]
[TD="class: cms_table_xl65, width: 64"][/TD]
[/TR]
[TR]
[TD="class: cms_table_xl66, width: 64"]93[/TD]
[TD="class: cms_table_xl65, width: 64"][/TD]
[TD="class: cms_table_xl65, width: 64"][/TD]
[/TR]
[TR]
[TD="class: cms_table_xl66, width: 64"]94[/TD]
[TD="class: cms_table_xl66, width: 64"]94[/TD]
[TD="class: cms_table_xl66, width: 64"]3[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl66, width: 64"]95[/TD]
[TD="class: cms_table_xl65, width: 64"][/TD]
[TD="class: cms_table_xl65, width: 64"][/TD]
[/TR]
[TR]
[TD="class: cms_table_xl66, width: 64"]96[/TD]
[TD="class: cms_table_xl66, width: 64"]96[/TD]
[TD="class: cms_table_xl66, width: 64"]2[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl66, width: 64"]97[/TD]
[TD="class: cms_table_xl65, width: 64"][/TD]
[TD="class: cms_table_xl65, width: 64"][/TD]
[/TR]
[TR]
[TD="class: cms_table_xl66, width: 64"]98[/TD]
[TD="class: cms_table_xl65, width: 64"][/TD]
[TD="class: cms_table_xl65, width: 64"][/TD]
[/TR]
[TR]
[TD="class: cms_table_xl66, width: 64"]99[/TD]
[TD="class: cms_table_xl66, width: 64"]99[/TD]
[TD="class: cms_table_xl66, width: 64"]3[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl66, width: 64"]100[/TD]
[TD="class: cms_table_xl65, width: 64"][/TD]
[TD="class: cms_table_xl65, width: 64"][/TD]
[/TR]
[TR]
[TD="class: cms_table_xl66, width: 64"]99[/TD]
[TD="class: cms_table_xl66, width: 64"]99[/TD]
[TD="class: cms_table_xl65, width: 64"][/TD]
[/TR]
[TR]
[TD="class: cms_table_xl66, width: 64"]98[/TD]
[TD="class: cms_table_xl65, width: 64"][/TD]
[TD="class: cms_table_xl65, width: 64"][/TD]
[/TR]
[TR]
[TD="class: cms_table_xl66, width: 64"]97[/TD]
[TD="class: cms_table_xl65, width: 64"][/TD]
[TD="class: cms_table_xl65, width: 64"][/TD]
[/TR]
[TR]
[TD="class: cms_table_xl66, width: 64"]96[/TD]
[TD="class: cms_table_xl66, width: 64"]96[/TD]
[TD="class: cms_table_xl66, width: 64"]3[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl66, width: 64"]95[/TD]
[TD="class: cms_table_xl65, width: 64"][/TD]
[TD="class: cms_table_xl65, width: 64"][/TD]
[/TR]
[TR]
[TD="class: cms_table_xl66, width: 64"]96[/TD]
[TD="class: cms_table_xl66, width: 64"]96[/TD]
[TD="class: cms_table_xl65, width: 64"][/TD]
[/TR]
[TR]
[TD="class: cms_table_xl66, width: 64"]97[/TD]
[TD="class: cms_table_xl65, width: 64"][/TD]
[TD="class: cms_table_xl65, width: 64"][/TD]
[/TR]
[TR]
[TD="class: cms_table_xl66, width: 64"]96[/TD]
[TD="class: cms_table_xl66, width: 64"]96[/TD]
[TD="class: cms_table_xl65, width: 64"][/TD]
[/TR]
[TR]
[TD="class: cms_table_xl66, width: 64"]95[/TD]
[TD="class: cms_table_xl65, width: 64"][/TD]
[TD="class: cms_table_xl65, width: 64"][/TD]
[/TR]
[TR]
[TD="class: cms_table_xl66, width: 64"]94[/TD]
[TD="class: cms_table_xl66, width: 64"]94[/TD]
[TD="class: cms_table_xl66, width: 64"]-2[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl65, width: 64"][/TD]
[TD="class: cms_table_xl65, width: 64"][/TD]
[TD="class: cms_table_xl65, width: 64"][/TD]
[/TR]
[TR]
[TD="class: cms_table_xl65, width: 64"][/TD]
[TD="class: cms_table_xl65, width: 64"]Net Total[/TD]
[TD="class: cms_table_xl66, width: 64"]9[/TD]
[/TR]
</tbody>[/TABLE]
You'll notice that 3 is the difference between 91 and 94. 2 is the difference between 96 and 94. 3 is the difference between 99 and 96. 99 repeats twice, so we continue to add 3, which is the difference between 96 and 99. Then, 96 is repeated 3x so we now subtract 2, which is the difference between 94 and 96. If the numbers would continue to decrease one or two at a time, the formula should continue to add the differences until the number is repeated 3 or more odd times. As long as it's repeated once or an even amount of times, it should continue to add the difference instead of subtract it. It should only subtract the difference if the number is repeated 3 or more odd times. I want to be able to copy this down 30k rows again - but don't worry about how many columns it takes to come to a conclusion. My comp can handle it

Hope I was clear. Lemme know if you need any more clarification.
Thanks!