Dear All Expert,
I have a number in table range as show below and how to make the tolerance formula.
[TABLE="width: 132"]
<tbody>[TR]
[TD]Week[/TD]
[TD]Date[/TD]
[TD]Output[/TD]
[TD]Trigger[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]31 Aug[/TD]
[TD]206[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]30 Aug[/TD]
[TD]201[/TD]
[/TR]
[TR]
[TD]29 Aug[/TD]
[TD]196[/TD]
[/TR]
[TR]
[TD]28 Aug[/TD]
[TD]206[/TD]
[/TR]
[TR]
[TD]27 Aug[/TD]
[TD]187[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]26 Aug[/TD]
[TD]199[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]25 Aug[/TD]
[TD]195[/TD]
[/TR]
[TR]
[TD]24 Aug[/TD]
[TD]202[/TD]
[/TR]
[TR]
[TD]23 Aug[/TD]
[TD]208[/TD]
[/TR]
[TR]
[TD]22 Aug[/TD]
[TD]209[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]21 Aug[/TD]
[TD]200[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]20 Aug[/TD]
[TD]130[/TD]
[/TR]
[TR]
[TD]19 Aug[/TD]
[TD]160[/TD]
[/TR]
[TR]
[TD]18 Aug[/TD]
[TD]145[/TD]
[/TR]
[TR]
[TD]17 Aug[/TD]
[TD]170[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]16 Aug[/TD]
[TD]190[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]15 Aug[/TD]
[TD]150[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14 Aug[/TD]
[TD]160[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]13 Aug[/TD]
[TD]130[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Appreciate for your kind helpful.
I have a number in table range as show below and how to make the tolerance formula.
[TABLE="width: 132"]
<tbody>[TR]
[TD]Week[/TD]
[TD]Date[/TD]
[TD]Output[/TD]
[TD]Trigger[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]31 Aug[/TD]
[TD]206[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]30 Aug[/TD]
[TD]201[/TD]
[/TR]
[TR]
[TD]29 Aug[/TD]
[TD]196[/TD]
[/TR]
[TR]
[TD]28 Aug[/TD]
[TD]206[/TD]
[/TR]
[TR]
[TD]27 Aug[/TD]
[TD]187[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]26 Aug[/TD]
[TD]199[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]25 Aug[/TD]
[TD]195[/TD]
[/TR]
[TR]
[TD]24 Aug[/TD]
[TD]202[/TD]
[/TR]
[TR]
[TD]23 Aug[/TD]
[TD]208[/TD]
[/TR]
[TR]
[TD]22 Aug[/TD]
[TD]209[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]21 Aug[/TD]
[TD]200[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]20 Aug[/TD]
[TD]130[/TD]
[/TR]
[TR]
[TD]19 Aug[/TD]
[TD]160[/TD]
[/TR]
[TR]
[TD]18 Aug[/TD]
[TD]145[/TD]
[/TR]
[TR]
[TD]17 Aug[/TD]
[TD]170[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]16 Aug[/TD]
[TD]190[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]15 Aug[/TD]
[TD]150[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14 Aug[/TD]
[TD]160[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]13 Aug[/TD]
[TD]130[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Appreciate for your kind helpful.