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
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Aug 09, 2022

Nibmus 

Approximately the same as PeterBartholomew1 solution, but works on less modern Excel

=IFERROR(
    IF( B3 = "",
        AGGREGATE(15,6, (ROW(Formula)-ROW($B$2)) /
                        ISERROR( MATCH(ROW(Formula) - ROW($G$2), Formula, 0 ) ),
                  ROW() - ROW($G$2) - COUNTA($B$3:B3) ),
    B3 ),
 "" )

Above in G3 and drag down till empty cells appear.

Resources