Forum Discussion

MT3's avatar
MT3
Copper Contributor
Mar 26, 2026

Filling a column with succeeding lists

Hi, I need a list of files, with numbers starting from 001 for each box. Adding the number for one box is easy but I have thousands of them. A box number is like "0001AA0001". The first number and ...
excel
Formulas and Functions
Macros and VBA
Office Scripts
PeterBartholomew1's avatar
PeterBartholomew1
Silver Contributor
Mar 29, 2026
= FILE.NUMBER(boxNumber)

where

FILE.NUMBER = LAMBDA(box,
    LET(
        change?, N(DROP(VSTACK("", box), -1) <> box),
        fileNum, SCAN(0, change?, LAMBDA(num, ch?, IF(ch?, 1, num+1))),
        box & "/" & TEXT(fileNum, "000")
    )
);

If you use 365 then the Lambda function FILE.NUMBER would product the required list from the box numbers.