Checking matching cells and not matching???

[natheplas]

Hi All,

I have a list of numbers on one column and then a list of numbers on the column next to it.

I need to find out when the second number is different from the previous row.

Its like an exact formula i need - I will show to help explain.

So please see below. How can i get a formula that checks on column A to see previous column B and if it is different report false or something?

Please help.


10 1
10 1
10 1
11 2
11 2
11 3 difference
12 7
12 7
12 7
13 9
13 9
13 10 difference

 

[njimack]

Excel Workbook
	A	B	C
1	10	1
2	10	1
3	10	1
4	11	2
5	11	2
6	11	3	difference
7	12	7
8	12	7
9	12	7
10	13	9
11	13	9
12	13	10	difference
Sheet2

 

[natheplas]

Thank you so much! That was exactly what I wanted.

I'm also really struggling with this formula:

=SUMPRODUCT((C5:C8=C10)*(SUBTOTAL(103,OFFSET(C5,ROW(C5:C8)-MIN(ROW(C5:C8)),0))))

Instead of '=C10' , I want it to count any negative number and any zero.

For example if it was 1, 2, -4, 0, 0, -9, 0, -7, -6, 10, it would count 7

Do you know how to amend this formula so it does that?

I need to use something like this so that when the filters change it only counts whats visible.

Thanks so much for your help!

 

[njimack]

Just change =C10 to <=0

 

[natheplas]

Thank you! :D