=LET(dataA,A3:C22,dataB,E3:G10,cc,LAMBDA(x,y,CHOOSECOLS(x,y)),f,LAMBDA(dataA,dataB,LET(keyStr,INDEX(dataB,1,1),tempKeys,TEXTSPLIT(keyStr,"/"),keys,IF(COLUMNS(tempKeys)>1,tempKeys,LET(tempKeys,TEXTSPLIT(keyStr,"-"),s,INDEX(cc(tempKeys,1),1),e,INDEX(cc(tempKeys,-1),1),SEQUENCE(,e-s+1,s))),logical,byrow(cc(dataA,1)&cc(dataA,2)=keys&INDEX(dataB,1,2),LAMBDA(x,OR(x))),result,HSTACK(TAKE(dataB,1,2),SUM(cc(FILTER(dataA,logical,0),-1))),nextDataA,FILTER(dataA,NOT(logical)),nextDataB,DROP(dataB,1),CHOOSE(OR(ISERROR(nextDataA))*2+OR(ISERROR(nextDataB))+1,VSTACK(result,f(nextDataA,nextDataB)),VSTACK(result,nextDataA),VSTACK(result,HSTACK(TAKE(nextDataB,,2),SEQUENCE(ROWS(nextDataB),,0,0))),result))),resultA,f(dataA,dataB),resultB,cc(EXPAND(dataB,ROWS(resultA),,0),-1),VSTACK({"编号","品名","系统A数量","系统B数量","是否一致"},HSTACK(resultA,resultB,IF(cc(resultA,-1)=resultB,"√","×"))))