用函数公式实现提取不重复项

lrccn

求大家帮忙解决，提取不重复项。

温馨豆

E3数组公式：

1. =INDEX(C:C,SMALL(IF((MATCH(B$3:B$26&C$3:C$26,B:B&C:C,)=ROW($3:$26))*(B$3:B$26=4)*(C$3:C$26>0),ROW($3:$26),520),ROW(A1)))&""

复制代码

我走我流

=IFERROR(OFFSET($C$2,SMALL(IFERROR(IF(MATCH(LEFT(E$2)&$C$3:$C$26,IF($C$3:$C$26<>"",$B$3:$B$26&$C$3:$C$26),)=ROW($1:$24),ROW($1:$24)),9^9),ROW(A1)),),"")
数组下拉

江苏永能朱兴华

数组：
=INDEX(C:C,MIN(IF(NOT(COUNTIF(E$2:E2,C$3:C$26))*(B$3:B$26=4)*(C$3:C$26>0),ROW($3:$26),99)))&""

sdc3211772

F3：=IFERROR(OFFSET($C$2,MATCH(0,COUNTIF(F$2:F2,IF(($B$3:$B$26=4)*($C$3:$C$26<>""),$C$3:$C$26,$F$2)),),),"")
三键

mengrs

=IFERROR(INDEX(C:C,2+MATCH(1,(COUNTIF(F$1:F2,C$3:C$26&"")=0)*(B$3:B$26=4),0)),"")
数组公式

laowuwyx

1. =LOOKUP(,0/FREQUENCY(1,(B$3:B$26=4)*(C$3:C$26>0)-COUNTIF(E$2:E2,C$3:C$26)),C$3:C4)&""

复制代码

普通公式。