Testing criteria across multiple rows

[HNExcel]

Hi there,

This is probably a really simple question, but I have been struggling to find a solution.

The example below will help;

I am able to manually enter when the condition is met, i.e. when the value in A exceeds the previous value in B which is not equal to zero.

I want to be able to add a formula in that will do this for me, i.e. it will look at the value in A and check whether or not it is greater than the previous B which is not equal to zero...can anyone help?

<table x:str="" style="border-collapse: collapse; width: 460pt;" width="612" border="0" cellpadding="0" cellspacing="0"><col style="width: 48pt;" width="64"> <col style="width: 28pt;" span="2" width="37"> <col style="width: 328pt;" width="437"> <col style="width: 28pt;" width="37"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt; width: 48pt;" width="64" height="17">
</td> <td class="xl25" style="border-left: medium none; width: 28pt;" width="37">A</td> <td class="xl25" style="border-left: medium none; width: 28pt;" width="37">B</td> <td class="xl25" style="border-left: medium none; width: 328pt;" width="437">Mark when A is greater than previous B which is not equal to zero</td> <td class="xl24" style="border-left: medium none; width: 28pt;" width="37">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="border-top: medium none; height: 12.75pt;" height="17">
</td> <td class="xl26" style="border-top: medium none; border-left: medium none;" x:num="">0</td> <td class="xl26" style="border-top: medium none; border-left: medium none;" x:num="">11</td> <td class="xl26" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="border-top: medium none; height: 12.75pt;" height="17">
</td> <td class="xl26" style="border-top: medium none; border-left: medium none;" x:num="">10</td> <td class="xl26" style="border-top: medium none; border-left: medium none;" x:num="">0</td> <td class="xl26" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="border-top: medium none; height: 12.75pt;" height="17">
</td> <td class="xl26" style="border-top: medium none; border-left: medium none;" x:num="">8</td> <td class="xl26" style="border-top: medium none; border-left: medium none;" x:num="">0</td> <td class="xl26" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="border-top: medium none; height: 12.75pt;" height="17">
</td> <td class="xl26" style="border-top: medium none; border-left: medium none;" x:num="">20</td> <td class="xl26" style="border-top: medium none; border-left: medium none;" x:num="">0</td> <td class="xl26" style="border-top: medium none; border-left: medium none;">x</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="border-top: medium none; height: 12.75pt;" height="17">
</td> <td class="xl26" style="border-top: medium none; border-left: medium none;" x:num="">0</td> <td class="xl26" style="border-top: medium none; border-left: medium none;" x:num="">12</td> <td class="xl26" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="border-top: medium none; height: 12.75pt;" height="17">
</td> <td class="xl26" style="border-top: medium none; border-left: medium none;" x:num="">30</td> <td class="xl26" style="border-top: medium none; border-left: medium none;" x:num="">0</td> <td class="xl26" style="border-top: medium none; border-left: medium none;">x</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="border-top: medium none; height: 12.75pt;" height="17">
</td> <td class="xl26" style="border-top: medium none; border-left: medium none;" x:num="">20</td> <td class="xl26" style="border-top: medium none; border-left: medium none;" x:num="">0</td> <td class="xl26" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="border-top: medium none; height: 12.75pt;" height="17">
</td> <td class="xl26" style="border-top: medium none; border-left: medium none;" x:num="">10</td> <td class="xl26" style="border-top: medium none; border-left: medium none;" x:num="">0</td> <td class="xl26" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="border-top: medium none; height: 12.75pt;" height="17">
</td> <td class="xl26" style="border-top: medium none; border-left: medium none;" x:num="">0</td> <td class="xl26" style="border-top: medium none; border-left: medium none;" x:num="">60</td> <td class="xl26" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="border-top: medium none; height: 12.75pt;" height="17">
</td> <td class="xl26" style="border-top: medium none; border-left: medium none;" x:num="">50</td> <td class="xl26" style="border-top: medium none; border-left: medium none;" x:num="">0</td> <td class="xl26" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="border-top: medium none; height: 12.75pt;" height="17">
</td> <td class="xl26" style="border-top: medium none; border-left: medium none;" x:num="">70</td> <td class="xl26" style="border-top: medium none; border-left: medium none;" x:num="">0</td> <td class="xl26" style="border-top: medium none; border-left: medium none;">x</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="border-top: medium none; height: 12.75pt;" height="17">
</td> <td class="xl26" style="border-top: medium none; border-left: medium none;" x:num="">0</td> <td class="xl26" style="border-top: medium none; border-left: medium none;" x:num="">42</td> <td class="xl26" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="border-top: medium none; height: 12.75pt;" height="17">
</td> <td class="xl26" style="border-top: medium none; border-left: medium none;" x:num="">45</td> <td class="xl26" style="border-top: medium none; border-left: medium none;" x:num="">0</td> <td class="xl26" style="border-top: medium none; border-left: medium none;">x</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="border-top: medium none; height: 12.75pt;" height="17">
</td> <td class="xl26" style="border-top: medium none; border-left: medium none;" x:num="">46</td> <td class="xl26" style="border-top: medium none; border-left: medium none;" x:num="">0</td> <td class="xl26" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="border-top: medium none; height: 12.75pt;" height="17">
</td> <td class="xl26" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl26" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl26" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> </tr> </tbody></table>

 

[njimack]

I have different results to you, but this is what youve asked for...

Excel Workbook
	A	B	C
1	A	B
2	0	11
3	10	0
4	8	0
5	20	0	x
6	0	12
7	30	0	x
8	20	0	x
9	10	0
10	0	60
11	50	0
12	70	0	x
13	0	42
14	45	0	x
15	46	0	x
Sheet1

 

[HNExcel]

Perfect thanks