Forum Discussion
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 ...
You may try the following formula-
=MAP(A2:A10,LAMBDA(x,x&"/"&TEXT(COUNTIFS(A2:x,x),"000")))