; 07 and above: office button in the upper left corner, excel option, formula, check iterative calculation.
, the maximum number of iterations is changed to 1, and the input formula of u 1 is = if (cell ("address") = "$ d $"&; Row (), U 1+ 1, U 1), press enter, and drop down, then column d is edited once, and column u is correspondingly added with 1. However, there is a premise that you can't use this file by opening other files first, and you can use other files normally by opening this file first.