Forum Discussion

boukasa's avatar
boukasa
Brass Contributor
Feb 25, 2023
Solved

Increment a column only when a corresponding column changes, in a Lambda

I am trying to write a lambda that takes a sorted array an produces a corresponding numbering column that increments when the value in the source array changes. Like this:   param result 1 ...
  • JosWoolley's avatar
    Feb 26, 2023

    boukasa

    Another

    =LET(
        ζ, XMATCH(A2:A9, A2:A9),
        XMATCH(ζ, UNIQUE(ζ))
    )

     Regards

Resources