Google表单根据值返回一系列连续的值 [英] Google sheets return a string of concatenated values from a range based on value

问题描述

我很欣赏这个问题可能出现在Stackexchange网站上，但这是我经常使用的最常见的问题，并且我不确定是否有更合适的问题 - 所以如果需要，可以随意移动它。

基本上我有以下情况：

我在Google工作表中试图做的是编写一个公式，该公式将返回给我一个连接字符串的球员姓名需要物品，在老板对应的单元格中。例如。 B9会将Player 2，Player 4改为Player 3，Player 4。

不确定Google表格中是否可以这样做;我确定它是可以使用有用的指针。

解决方案

是的，这很有趣我不知道在Excel中这样做的方式，因为concatenate函数doesn'您可以在Google表格中使用它： -

  = ArrayFormula（CONCATENATE（IF（B4：B7 < >，$ A4：$ A7&，）））
  

几乎是你想要的 - 使用空格而不是逗号作为分隔符）。

I appreciate this question might be on the incorrect Stackexchange website but this is the one I frequent most often and wasn't sure of a more appropriate one - so feel free to move it mods if required.

Basically I have the following scenario:

What I'm trying to do in Google sheets is write a formula which will return me a concatenated string of the name of players that need items, in the cell which corresponds with the boss. E.g. B9 would read "Player 2, Player 4" C9 would read "Player 3, Player 4".

Unsure if this is even possible in Google Sheets; I'm sure it is but could use a helpful pointer. Thanks in advance.

解决方案

Yes it's interesting I don't know a way of doing it in Excel because the concatenate function doesn't work with arrays, but you can do it in Google Sheets:-

=ArrayFormula(CONCATENATE(IF(B4:B7<>"",$A4:$A7&" ","")))

(this is almost what you want - uses a space instead of a comma as separator).

这篇关于Google表单根据值返回一系列连续的值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！