|
本帖最后由 wangjianff 于 2013-8-16 16:23 编辑
来个笨方法 C2单元格数组公式下拉- =LEFT(A2&SUM(N(A$2:A2&B$2:B2=A2&"一级"))&"."&LOOKUP(9E+307,FREQUENCY((A$2:A2&B$2:B2=A2&"二级")*ROW($2:2),MAX((A1:A$2&B1:B$2=A2&"一级")*ROW(1:$2))))&"."&LOOKUP(9E+307,FREQUENCY((A$2:A2&B$2:B2=A2&"三级")*ROW($2:2),MAX((A1:A$2&B1:B$2=A2&"二级")*ROW(1:$2))))&"."&LOOKUP(9E+307,FREQUENCY((A$2:A2&B$2:B2=A2&"四级")*ROW($2:2),MAX((A1:A$2&B1:B$2=A2&"三级")*ROW(1:$2)))),FIND(LEFT(B2,1),"一二三四")*2)
复制代码 |
|