Forum Discussion
Excel Dynamic Array - Resetting a Row Count
Sharing a problem and solution which I believe might be helpful. I've been working for a while on coming up with a way to sort and rank a list of customer / item / other identifier fields which a...
=DROP(
REDUCE(0,SEQUENCE(ROWS(C2:C26)),
LAMBDA(u,v,
VSTACK(u,COUNTIF(TAKE(C2:C26,v),INDEX(C2:C26,v))
))),1)
LAMBDA and REDUCE should do what you are looking for if i correctly understand the question.