请教筛选公式数组含义 =INDEX(A:B,SMALL(IF(MATCH(A$2:A$19&B$2:B$19,A$2:A$19&B$2:B$19,)=ROW($1:$18),R =INDEX(A:B,SMALL(IF(MATCH(A$2:A$19&B$2:B$19,A$2:A$19&B$2:B$19,)=ROW($1:$18),ROW($2:$19),4^8),ROW(A1)),{1,2})&""
来源:学生作业帮助网 编辑:作业帮 时间:2024/06/21 10:10:04
![请教筛选公式数组含义 =INDEX(A:B,SMALL(IF(MATCH(A$2:A$19&B$2:B$19,A$2:A$19&B$2:B$19,)=ROW($1:$18),R =INDEX(A:B,SMALL(IF(MATCH(A$2:A$19&B$2:B$19,A$2:A$19&B$2:B$19,)=ROW($1:$18),ROW($2:$19),4^8),ROW(A1)),{1,2})&](/uploads/image/z/3624626-2-6.jpg?t=%E8%AF%B7%E6%95%99%E7%AD%9B%E9%80%89%E5%85%AC%E5%BC%8F%E6%95%B0%E7%BB%84%E5%90%AB%E4%B9%89+%3DINDEX%28A%3AB%2CSMALL%28IF%28MATCH%28A%242%3AA%2419%26B%242%3AB%2419%2CA%242%3AA%2419%26B%242%3AB%2419%2C%29%3DROW%28%241%3A%2418%29%2CR%E3%80%80%E3%80%80%3DINDEX%28A%3AB%2CSMALL%28IF%28MATCH%28A%242%3AA%2419%26B%242%3AB%2419%2CA%242%3AA%2419%26B%242%3AB%2419%2C%29%3DROW%28%241%3A%2418%29%2CROW%28%242%3A%2419%29%2C4%5E8%29%2CROW%28A1%29%29%2C%7B1%2C2%7D%29%26%22%22)
请教筛选公式数组含义 =INDEX(A:B,SMALL(IF(MATCH(A$2:A$19&B$2:B$19,A$2:A$19&B$2:B$19,)=ROW($1:$18),R =INDEX(A:B,SMALL(IF(MATCH(A$2:A$19&B$2:B$19,A$2:A$19&B$2:B$19,)=ROW($1:$18),ROW($2:$19),4^8),ROW(A1)),{1,2})&""
请教筛选公式数组含义 =INDEX(A:B,SMALL(IF(MATCH(A$2:A$19&B$2:B$19,A$2:A$19&B$2:B$19,)=ROW($1:$18),R
=INDEX(A:B,SMALL(IF(MATCH(A$2:A$19&B$2:B$19,A$2:A$19&B$2:B$19,)=ROW($1:$18),ROW($2:$19),4^8),ROW(A1)),{1,2})&""
请教筛选公式数组含义 =INDEX(A:B,SMALL(IF(MATCH(A$2:A$19&B$2:B$19,A$2:A$19&B$2:B$19,)=ROW($1:$18),R =INDEX(A:B,SMALL(IF(MATCH(A$2:A$19&B$2:B$19,A$2:A$19&B$2:B$19,)=ROW($1:$18),ROW($2:$19),4^8),ROW(A1)),{1,2})&""
总体意思:按顺序列出AB两列不重复项.数组公式.
函数说明:
index(a:b,...,{1,2}) 某行的1~2列
small(...,row(a1)) (下拉)第1、2、3.个最小值
match(..,...,) 查找,第1次出现行数=行数当前row(..)