Flag every time a value changes in a column

Question

INPUT:

Desired OUTPUT:

I am already using a multi- row formula to flag this. But I am having problems with the result  I am getting, Instead of the "Desired OUTPUT" mentioned above  I am getting this. As you can see the formula works for some vales in the "DecodedValue" column. I don't know why it doesn't work for each change in value.

Multi-row formula being used:

INPUT-3.xlsx

OUTPUT-3.xlsx

MarioAA · Accepted Answer

Hello!

I think the formula should be just if [Row-1:DecodedValue] = [DecodedValue] THEN 1 ELSE 0 ENDIF

Try this

Mario

CathyS_Slalom · Accepted Answer

Hi @bmittal11, you can use the formula below to get the desired output.

IF [DecodedValue] = [Row-1:DecodedValue] OR IsEmpty([Row-1:DecodedValue])
THEN 1
ELSE 0
ENDIF