Forum Discussion
boukasa
Feb 25, 2023Brass Contributor
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 ...
- Feb 26, 2023
OliverScheurich
Feb 26, 2023Gold Contributor
=SCAN(0,A2:A9,LAMBDA(i,a,IF(OFFSET(a,-1,0)=a,i,i+1)))Another alternative could be this formula.