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

[danrh · Accepted solution]

I think this was answered already here, but here's another option without using the Multi-row Formula: