|
..90*149=13410............
B2输入- =IF(ROW(B2)=2,OFFSET(表格2!$A$1,COUNTIF($A$2:A$19,"?"),),IF(OFFSET(表格2!$A$1,COUNTIF($A$2:A$19,"?")+COUNTIF(B$1:B1,"?"),)=B1,B1,""))&""
复制代码 不写通用了
相对要改一下
B21输入
=IF(ROW()=21,OFFSET(表格2!$B$1,COUNTIF($A$21:A$38,"?"),),IF(OFFSET(表格2!$B$1,COUNTIF($A$21:A$38,"?")+COUNTIF(B$20:B20,"?"),)=B20,B20,""))&""
相对B2的就将2改为21
A改为B
A2:A19改为A21:A38
B1改为B20
所有都是相对的吧
··
B40输入- =IF(ROW()=40,OFFSET(表格2!$C$1,COUNTIF($A$40:A$57,"?"),),IF(OFFSET(表格2!$C$1,COUNTIF($A$40:A$57,"?")+COUNTIF(B$39:B39,"?"),)=B39,B39,""))&""
复制代码 B59输入- =IF(ROW()=59,OFFSET(表格2!$D$1,COUNTIF($A$59:A$76,"?"),),IF(OFFSET(表格2!$D$1,COUNTIF($A$59:A$76,"?")+COUNTIF(B$58:B58,"?"),)=B58,B58,""))&""
复制代码 B78输入- =IF(ROW()=78,OFFSET(表格2!$E$1,COUNTIF($A$78:A$95,"?"),),IF(OFFSET(表格2!$E$1,COUNTIF($A$78:A$95,"?")+COUNTIF(B$77:B77,"?"),)=B77,B77,""))&""
复制代码 都是输入后直接下拉到分隔那里再右拉即可
感觉1W多单元格搞公式还是不怎么适合
哎
见附件吧
后面的自己相对改一下
都2点多M了都
|
|