Expression for ID Using MultiRow Formula

[Syarifhidayat]

Hey Guys,

I need some help to figure out an epression that I should use at multirow formula to get result below

Input:

Value

A

B

C

D

E

F

Output:

Value	ID
A	1
B	1
C	2
D	2
E	3
F	3

[MarqueeCrew · Accepted solution]

@Syarifhidayat,

Here's the formula:

IIF([Row-2:ID]==[Row-1:ID],[Row-1:ID]+1,[Row-1:ID])

You need to set "Num Rows" to 2 in the configuration.

Cheers,

Mark