=TEXTJOIN(",",TRUE,A2:A13) 再看下图所示这个表格,想要把书名对应的姓名合并到一个单元格中:首先可以在G2单元格输入FILTER函数:=FILTER($A$2:$A$13,$B$2:$B$13=F2,"") 在写完FILTER之后,可以用TEXTJOIN函数进行合并: =TEXTJOIN(",",TRUE,FILTER($A$2:$A$13,$B$2:$B$13=F2,"")),最后做...
=TEXTJOIN(",",TRUE,A2:A13) 再看下图所示这个表格,想要把书名对应的姓名合并到一个单元格中:首先可以在G2单元格输入FILTER函数:=FILTER($A$2:$A$13,$B$2:$B$13=F2,"") 在写完FILTER之后,可以用TEXTJOIN函数进行合并: =TEXTJOIN(",",TRUE,FILTER($A$2:$A$13,$B$2:$B$13=F2,"")),最后做...
=TEXTJOIN(",",TRUE,A2:A13) 再看下图所示这个表格,想要把书名对应的姓名合并到一个单元格中:首先可以在G2单元格输入FILTER函数:=FILTER($A$2:$A$13,$B$2:$B$13=F2,"") 在写完FILTER之后,可以用TEXTJOIN函数进行合并: =TEXTJOIN(",",TRUE,FILTER($A$2:$A$13,$B$2:$B$13=F2,"")),最后做...
示例3:提取指定人员销售的商品名称 新版本可以使用公式=UNIQUE(FILTER(C2:C15,B2:B15=F2))轻松解决。 公式原理:先用FILTER函数筛选出指定人员销售的所有商品名称,然后再用UNIQUE函数去除重复的内容,简洁明了。 FILTER函数用法可以戳这个链接:FILTER函数的4种高能用法 如果用老版本解决这个问题的话,公式是这样的: =IF...
In this video, I am going to introduce 5 new functions that you should know, These functions are available in Excel365 or Excel2021, if you don’t have the two Excel versions installed, you can also us, 视频播放量 118、弹幕量 0、点赞数 3、投硬币枚数 0、
MATCH+VLOOKUP, IF+AND, MID+FIND这些经典的万金油搭配都是过去若干年中大量用户逐步积累总结而来,随着互联网的发达开始广为流传。 Excel 2021版本推出的新函数差不多两年了,机智的打工人也开始逐步创造一些万金油式的搭配,一起来看一下吧。 FILTER+UNIQUE 筛选去重 ...
TEXTJOIN(" / ",1,UNIQUE(FILTER(A:A,B:B="CAR"))) This gives me A / B / C. But group A CAR didn't make any after YR 1. I am attempting to list all unique groups for a certain criteria if the group has a cumulative value over 0 from year 2 and out. ...
I have signed up for the Insider Fast updates. The UNIQUE & FILTER functions are part of it, but I am still not able to get the functions in my Excel (Windows desktop & Mac). Does anyone know why? Or how to get them. Really wishing for it, as I am using complex...
In Excel, there are several ways to filter for unique values—or remove duplicate values: To filter for unique values, clickData >Sort & Filter >Advanced. To remove duplicate values, clickData > Data Tools>Remove Duplicates. To highlight unique or duplicate values, use theConditi...
In Excel, there are several ways to filter for unique values—or remove duplicate values: To filter for unique values, clickData >Sort & Filter >Advanced. To remove duplicate values, clickData > Data Tools>Remove Duplicates. To highlight unique or duplicate values, use theCondi...