=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,"")),最后做...
MATCH+VLOOKUP, IF+AND, MID+FIND这些经典的万金油搭配都是过去若干年中大量用户逐步积累总结而来,随着互联网的发达开始广为流传。 Excel 2021版本推出的新函数差不多两年了,机智的打工人也开始逐步创造一些万金油式的搭配,一起来看一下吧。 FILTER+UNIQUE 筛选去重 =UNIQUE(FILTER(B2:B11,C2:C11="华南")) FILTE...
If I've understood what you were asking / proposing, yes you are right. Yesterday evening, everything was fine with Excel. This morning there were a number of problems. I also thought it might be linked to a problem with the "beta" channel and went back to "standard" but that did no...
I'm working at a new company, and my very first spreadsheets hit 32bit 2GB thresholds immediately 64bit excel was installed, and my spreadsheets lost...
In Excel, there are several ways to filter for unique values—or remove duplicate values: To filter for unique values, selectData >Sort & Filter >Advanced. To remove duplicate values, selectData > Data Tools>Remove Duplicates. To highlight unique or duplicate values, from theHome...
Effortlessly highlight, filter, and sort data with Copilot in Excel We're giving you a free trial of Copilot Pro. Activate now The UNIQUE function returns a list of unique values in a list or range. Return unique values from a list of values ...
示例一:如图所示:单条件查找返回满足多个条件的记录公式为:=FILTER(A2:E13,B2:B13=H2) 公式解释:此函数根据给定的条件(在这里是B2:B13=H2)从A2:E13范围中筛选出满足条件的行。 PS:出版的Word新书《Word效率手册轻松设计高品质版面》,京东有售,喜欢的话可以购买支持一下。
新版本可以使用公式=UNIQUE(FILTER(C2:C15,B2:B15=F2))轻松解决。 公式原理:先用FILTER函数筛选出指定人员销售的所有商品名称,然后再用UNIQUE函数去除重复的内容,简洁明了。 FILTER函数用法可以戳这个链接:FILTER函数的4种高能用法 如果用老版本解决这个问题的话,公式是这样的: ...
Here is the step-by-step process for counting distinct values in Excel: Choose the range of cells in which you want to find distinct values. Go to the Data tab in Excel and choose Advanced from the Sort & Filter field. On the next screen, choose the “Copy to another location” option...