求助一下，去重函数unique 怎么能空格去掉？

jdjs893k

去重函数unique 怎么能空格去掉？，哪位大虾能指导下。谢谢





weibo.com/ttarticle/p/show?id=2309405028633491144893
weibo.com/ttarticle/p/show?id=2309405028633495601534
weibo.com/ttarticle/p/show?id=2309405028633499795534
weibo.com/ttarticle/p/show?id=2309405028633512378686
weibo.com/ttarticle/p/show?id=2309405028633520767122
weibo.com/ttarticle/p/show?id=2309405028633524961582
weibo.com/ttarticle/p/show?id=2309405028633533349899
weibo.com/ttarticle/p/show?id=2309405028633541738629
weibo.com/ttarticle/p/show?id=2309405028633550127130
weibo.com/ttarticle/p/show?id=2309405028633558515813
weibo.com/ttarticle/p/show?id=2309405028633562448113
weibo.com/ttarticle/p/show?id=2309405028633571098855
weibo.com/ttarticle/p/show?id=2309405028633634013500
weibo.com/ttarticle/p/show?id=2309405028633638207690
weibo.com/ttarticle/p/show?id=2309405028633646334030
weibo.com/ttarticle/p/show?id=2309405028633663373471
weibo.com/ttarticle/p/show?id=2309405028633667567866
weibo.com/ttarticle/p/show?id=2309405028633675956561
weibo.com/ttarticle/p/show?id=2309405028633688277177
weibo.com/ttarticle/p/show?id=2309405028633701122055
weibo.com/ttarticle/p/show?id=2309405028633709510698
weibo.com/ttarticle/p/show?id=2309405028633784746075
weibo.com/ttarticle/p/show?id=2309405028633818300436
weibo.com/ttarticle/p/show?id=2309405028633847923020
weibo.com/ttarticle/p/show?id=2309405028633910837433
weibo.com/ttarticle/p/show?id=2309405028633944129550
weibo.com/ttarticle/p/show?id=2309405028633948324033
weibo.com/ttarticle/p/show?id=2309405028633973489715
weibo.com/ttarticle/p/show?id=2309405028633981878314
weibo.com/ttarticle/p/show?id=2309405028634015694975
weibo.com/ttarticle/p/show?id=2309405028634066026907
weibo.com/ttarticle/p/show?id=2309405028634112163986
weibo.com/ttarticle/p/show?id=2309405028634120290355
weibo.com/ttarticle/p/show?id=2309405028634149912762
weibo.com/ttarticle/p/show?id=2309405028634154106943
weibo.com/ttarticle/p/show?id=2309405028634422542584
weibo.com/ttarticle/p/show?id=2309405028634430668827
weibo.com/ttarticle/p/show?id=2309405028634439057536
weibo.com/ttarticle/p/show?id=2309405028634451902630
weibo.com/ttarticle/p/show?id=2309405028634460028931
weibo.com/ttarticle/p/show?id=2309405028634477068368
weibo.com/ttarticle/p/show?id=2309405028634481262836
weibo.com/ttarticle/p/show?id=2309405028634485194985
weibo.com/ttarticle/p/show?id=2309405028634506428463
weibo.com/ttarticle/p/show?id=2309405028634544177276
weibo.com/ttarticle/p/show?id=2309405028634573275171
weibo.com/ttarticle/p/show?id=2309405028634607091863
weibo.com/ttarticle/p/show?id=2309405028634674200749
weibo.com/ttarticle/p/show?id=2309405028634678394891
weibo.com/ttarticle/p/show?id=2309405028634703560863
weibo.com/ttarticle/p/show?id=2309405028634707755054
weibo.com/ttarticle/p/show?id=2309405028634724270271
weibo.com/ttarticle/p/show?id=2309405028634732921100
weibo.com/ttarticle/p/show?id=2309405028634736853012
weibo.com/ttarticle/p/show?id=2309405028634762281253
weibo.com/ttarticle/p/show?id=2309405028634812350649
weibo.com/ttarticle/p/show?id=2309405028634846167052
weibo.com/ttarticle/p/show?id=2309405028634879721584
weibo.com/ttarticle/p/show?id=2309405028634946568227
weibo.com/ttarticle/p/show?id=2309405028634951024688
weibo.com/ttarticle/p/show?id=2309405028634976190747
weibo.com/ttarticle/p/show?id=2309405028634980122789
weibo.com/ttarticle/p/show?id=2309405028635001356421
weibo.com/ttarticle/p/show?id=2309405028635009745289
weibo.com/ttarticle/p/show?id=2309405028635013939248
weibo.com/ttarticle/p/show?id=2309405028635034910826
weibo.com/ttarticle/p/show?id=2309405028635076853827
weibo.com/ttarticle/p/show?id=2309405028635106213915
weibo.com/ttarticle/p/show?id=2309405028635135311908
weibo.com/ttarticle/p/show?id=2309405028635206615094
weibo.com/ttarticle/p/show?id=2309405028635215266094
weibo.com/ttarticle/p/show?id=2309405028635227586721
weibo.com/ttarticle/p/show?id=2309405028635244363963
weibo.com/ttarticle/p/show?id=2309405028635257208899
weibo.com/ttarticle/p/show?id=2309405028635265335420
weibo.com/ttarticle/p/show?id=2309405028635278180376
weibo.com/ttarticle/p/show?id=2309405028635286306847
weibo.com/ttarticle/p/show?id=2309405028635294957600
weibo.com/ttarticle/p/show?id=2309405028635365998621
weibo.com/ttarticle/p/show?id=2309405028635399815395
weibo.com/ttarticle/p/show?id=2309405028635433369832
weibo.com/ttarticle/p/show?id=2309405028635496284259
weibo.com/ttarticle/p/show?id=2309405028635508605022
weibo.com/ttarticle/p/show?id=2309405028635525644417
weibo.com/ttarticle/p/show?id=2309405028635554742387
weibo.com/ttarticle/p/show?id=2309405028635558936642
weibo.com/ttarticle/p/show?id=2309405028635584364830
weibo.com/ttarticle/p/show?id=2309405028635622113499
weibo.com/ttarticle/p/show?id=2309405028635655405614
weibo.com/ttarticle/p/show?id=2309405028635688960022
weibo.com/ttarticle/p/show?id=2309405028635689222252
weibo.com/ttarticle/p/show?id=2309405028635722514523
weibo.com/ttarticle/p/show?id=2309405028635751874769

安若浅笑

=UNIQUE(FILTER(A3:B17,A3:A17<>""))

袁勇

低版本：
=LOOKUP(1,0/FREQUENCY(1,(COUNTIFS($E$3:$E3,$A$4:$A20,$F$3:$F3,$B$4:$B20)=0)*($A$4:$A20<>"")),A$4:A20)&""

boyuanoffice

=DROP(UNIQUE(A:B),1)
如果unique有忽略空白单元格选项就好了, 省了好多麻烦

沈默00

=DROP(UNIQUE(A3:B24),-1)