你好,表格变化了,我不会公式变形,请问如图的数据形式,aj/ak/al怎么写公式
情侣_好物玩意
2024-09-28 00:01:32
最佳回答
aj4:=if(**err(find($a4,indirect("ac"&int((row()-4)/8)*8+11)&indirect("ad"&int((row()-4)/8)*8+11))),0,1)+if(**err(find($b4,indirect("ac"&int((row()-4)/8)*8+11)&indirect("ad"&int((row()-4)/8)*8+11))),0,1)+if(**err(find($c4,indirect("ac"&int((row()-4)/8)*8+11)&indirect("ad"&int((row()-4)/8)*8+11))),0,1)ak4:=if(**err(find($a4,indirect("ae"&int((row()-4)/8)*8+11))),0,1)+if(**err(find($b4,indirect("ae"&int((row()-4)/8)*8+11))),0,1)+if(**err(find($c4,indirect("ae"&int((row()-4)/8)*8+11))),0,1)al4:=if(**err(find($a4,indirect("af"&int((row()-4)/8)*8+11)&indirect("ag"&int((row()-4)/8)*8+11)&indirect("ah"&int((row()-4)/8)*8+11))),0,1)+if(**err(find($b4,indirect("af"&int((row()-4)/8)*8+11)&indirect("ag"&int((row()-4)/8)*8+11)&indirect("ah"&int((row()-4)/8)*8+11))),0,1)+if(**err(find($c4,indirect("af"&int((row()-4)/8)*8+11)&indirect("ag"&int((row()-4)/8)*8+11)&indirect("ah"&int((row()-4)/8)*8+11))),0,1)下拉填充 20210311