问题：Filter、Unique如何跳过隐藏行
数据源为A2:B12
以下公式对筛选同样有效
Filter
=IFERROR(INDEX(FILTER($A$2:$B$12,($A$2:$A$12="乙")*SUBTOTAL(103,OFFSET($A$1,ROW($1:$11),))),ROW(A1),COLUMN(A1)),"")
Unique
=IFERROR(INDEX(UNIQUE(FILTER(A2:A12,SUBTOTAL(103,OFFSET(A1,ROW(1:11),)))),ROW(A1)),"")标签：A1,INDEX,Filter,Unique,跳过,ROW From： https://www.cnblogs.com/officeplayer/p/16608580.html