Comparing data in each row of a single column

[Faithz]

Good Day All,

I am new to Alteryx and trying to figure out how to compare consecutive rows from a individual column and then give 0 if it matches and 1 if no match.

example:

reference number

1422632
1422632
1414505
1420044
1420044
1420044
1413297
1413297
1413297
1417531

then get a output that looks like below.

1422632	0
1422632	1
1414505	1
1420044	0
1420044	0
1420044	1
1413297	0
1413297	0
1413297	1
1417531	1

[Roberto1125]

Hi,   I have a very similar issue/need but am not able to reconcile the output of the Summarize Tool I use when counting distinct non-null values in my rows and using the Multi-Row formula tool using the following expression: 

IF [SO_ORDER_ID] != [Row-1:SO_ORDER_ID] OR [Row+1:SO_ORDER_ID] THEN 1 ELSE 0 ENDIF  

I end up with the correct value I'm expecting in the Summarize Tool, however the value from the above expression in the Multi-Row formula tool ends up being less than expected by a fair amount.   Any thoughts on how I can tweak the logic or settings used in the Multi-Row formula to have the two values be equal to each other?