本帖最后由 suye1010 于 2012-11-21 16:01 编辑
- =SUBSTITUTE(CHAR(64+INT((COUNTIF($E$3:$E3,LEFT($E3)&"*")-1)/LOOKUP(2,1/($A$3:$A$9=LEFT($E3)),$C$3:$C$9-$B$3:$B$9+1)))&MOD(COUNTIF($E$3:$E3,LEFT($E3)&"*")-1,LOOKUP(2,1/($A$3:$A$9=LEFT($E3)),$C$3:$C$9-$B$3:$B$9+1))+VLOOKUP(LEFT($E3),$A$3:$C$9,2,0),CHAR(64),)
复制代码
序号生成.zip
(6 KB, 下载次数: 5, 售价: 2 个金币)
|