Forum Discussion

Nibmus's avatar
Nibmus
Copper Contributor
Aug 06, 2022

How to have a list of numbers that skip when it gets to certain values?

I want to make a list of numbers. The thing is, some slots have already been filled by other numbers using a formula.         10     4       3       ...
excel
PeterBartholomew1's avatar
PeterBartholomew1
Silver Contributor
Aug 06, 2022

Nibmus 

A 365 solution.

= LET(
  k, SEQUENCE(ROWS(Formula)),
  missing, FILTER(k, ISERROR(XMATCH(k, Formula))),
  pointer, SCAN(0, Formula, LAMBDA(a,f, IF(f, a, a+1))),
  IF(Formula, Formula, INDEX(missing,pointer)))

 

 

Resources