英文:
Concatenate/Merge values based on multiple columns
问题
根据身高、体重和班级号，如果它们都匹配，然后在新列中写入以下输出：
| 共同特点很多的人的姓名（身高、体重和班级号） |
|---|
| Steve，Bob |
英文:
How can you concatenate/join or merge values based on multiple columns?
This is the initial table
| Name | Height | Weight | Class number |
|---|---|---|---|
| Mark | 1m80 | 80kg | 1 |
| Steve | 1m60 | 60kg | 2 |
| Bob | 1m60 | 60kg | 2 |
Based on the height, the weight and the class, if they match all then write in a new column the following output:
| Names of people that share a lot in common (height,weight and class number) |
|---|
| Steve,Bob |
答案1
得分: 2
如果您使用Microsoft-365，则可以尝试-
=TEXTJOIN("，", 1, FILTER($A$2:$A$4, ($B$2:$B$4=B2) * ($C$2:$C$4=C2) * ($D$2:$D$4=D2)))
英文:
If you are on Microsoft-365 then could try-
=TEXTJOIN(", ",1,FILTER($A$2:$A$4,($B$2:$B$4=B2)*($C$2:$C$4=C2)*($D$2:$D$4=D2)))
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论