To return TRUE value if customer ID matches in leading and next row

[BJSOON]

Hi, I am trying to create a new column whereby it returns TRUE value if Customer ID in the leading and next row match.  As an example:

Repeat Customer (new column)	Customer ID
TRUE	123
FALSE	123
FALSE	789
TRUE	456
FALSE	456

Thank you in advance! 

[LordNeilLord · Accepted solution]

Hey @BJSOON 

Multirow formula is your friend here!

It will be something like:

[Repeat Customer] = [Row+1:Repeat Customer]

[JulioMO · Accepted solution]

Hi @BJSOON ,

The tool you need to use is Multi-Row Formula. 

However, there are one tricky thing. In order to get a True/False, make sure you select "Bool" in the confiuration window. Additionally, I show you the expression I use to create the new column:

The output is: 

I attach the workflow.

Regards!