怎么把表1和表2中的数据，用函数公式在表3中，扣除重复值生成所需要的数据？

Question

用INDEX函数，设计公式

Answer 1

在sheet2的A列前面插入一列 A2=IF(B2>"",IF(COUNTIF(Sheet1!A:A,B2),"",ROW()),"") 下拉 sheet3 A2=IF(Sheet1!$A2>"",Sheet1!$A2,"") B2=IF(A2>"",IF(COUNTIF(Sheet2!B:B,A2),A2,""),IF(COUNT(Sheet2!A:A)>=COUNTIF(A$2:A2,""),VLOOKUP(SMALL(Sheet2!A:A,COUNTIF(A$2:A2,"")),Sheet2!A:B,2,0),"")) C2=IF(Sheet1!$A2>"",Sheet1!$B2,"") D2=IF(B2>"",VLOOKUP(B2,Sheet2!B:C,2,0),"") 全部下拉追问

A2=IF(Sheet1!$A2>"",Sheet1!$A2,"") B2=IF(A2>"",IF(COUNTIF(Sheet2!B:B,A2),A2,""),IF(COUNT(Sheet2!A:A)>=COUNTIF(A$2:A2,""),VLOOKUP(SMALL(Sheet2!A:A,COUNTIF(A$2:A2,"")),Sheet2!A:B,2,0),"")) C2=IF(Sheet1!$A2>"",Sheet1!$B2,"") D2=IF(B2>"",VLOOKUP(B2,Sheet2!B:C,2,0),"")
这个是一个公式，还是每列单元格的公式？