大家好，有个自动生成序列号的问题求教

我写的函数为“=IF(B2=B1,"OS"&"-"&E2&"-"&IF(B2=B1,REPT(MID(D1,6,4),1),ROW(A1)+$A$4)&"-"&COUNTIF($B$1:B2,B2),"OS"&"-"&E2&"-"&ROW(A1)+$A$4&"-"&1)”
麻烦大佬们看看要怎么修改

文件放在下面
链接: https://pan.baidu.com/s/1j4ugFPo2lguIrs_NvZIypg?pwd=99r2 提取码: 99r2 复制这段内容后打开百度网盘手机App，操作更方便哦

="OS-D-"&$A$4+ROW(A1)&"-"&COUNTIF(B$2:$B2,B2)
这样？

=CONCAT("OS-",IFNA(LOOKUP(B2,{"手机壳","A";"文件夹","B";"包包","C"}),"D"),"-",$A$4+XLOOKUP(B2,UNIQUE($B$2:$B$9),SEQUENCE(COUNTA(UNIQUE($B$2:$B$9)))),"-"&COUNTIF($B$2:B2,B2))