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 ...
=A2&"/"&TEXT(COUNTIFS($A$2:A2,A2),"000")The screenshot shows the formula in german Excel.