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 ...
excel
Formulas and Functions
  • JosWoolley's avatar
    JosWoolley
    Feb 26, 2023

    boukasa

    Another

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

     Regards

Patrick2788's avatar
Patrick2788
Silver Contributor
Feb 25, 2023

boukasa 

Here's a solution with MAP:

 

Dynamic named item 'param'
=LET(p, Sheet1!$D$2:$D$1000, nonblank, COUNTA(p), TAKE(p, nonblank))

Lambda 'Locate'.  To be used with MAP. Each element in the array will be matched within a unique list of the array.
=LAMBDA(e,XMATCH(e, UNIQUE(param)))

Sheet level formula:
=MAP(param,Locate)

Resources