将两个数据范围合并成一个范围(Google Drive Excel) [英] Combine two data ranges into one range (Google Drive Excel)
问题描述
FREQUENCY
函数。 示例:
第一个数据范围 - B5:F50
第二个数据范围 - J5:N50
Bins数据范围 - I5:I16
函数定义 - FREQUENCY(data_array; bins_array) code>
基本上我很懒惰,我不想重新整理我的excel脚本,以便并排吐出两个数据集,以便我可以引用它们类似 B5:K50
范围。有什么办法可以使用某种公式将两个数据集合到 data_array
中?也许最终会出现一些沿着 = FREQUENCY((B5:F50,J5:N50))的行; I5:I16)
?
BTW:
= FREQUENCY(B5:F50; I5:I16)
= FREQUENCY(J5:N50; I5:I16)
只为自己的文件工作。 p>
更新
2013 MS Excel(无关)
在MS Excel中 FREQUENCY
函数接受一个union作为第一个参数,即用逗号分隔并括在括号中的引用列表,例如
= FREQUENCY((B5:F50,J5:N50),I5:I16)
注意:箱阵列如果需要,也可以是联盟
在Google表中,我不认为同样的事情是可能的 - 可能会有一个聪明的解决方法,但是我不知道它
Hi there I am looking to combine two data ranges/arrays into one in order to feed them into excel FREQUENCY
function.
Example:
First data range - B5:F50
Second data range - J5:N50
Bins data range - I5:I16
Function definition - FREQUENCY(data_array; bins_array)
Basically I am lazy and I don't want to reshuffle my excel script to spit out both datasets side by side so that I can reference them using something like B5:K50
range. Is there any way I can combine both datasets into data_array
using some kind of formula? Maybe to end up with something along the line of =FREQUENCY((B5:F50,J5:N50); I5:I16)
?
BTW: Either of
=FREQUENCY(B5:F50; I5:I16)
=FREQUENCY(J5:N50; I5:I16)
work just file on their own for me.
Update
Actual formula definition FREQUENCY(data, classes)
2013 MS Excel (unrelated)
In MS Excel FREQUENCY
function accepts a "union" as the first argument, i.e. a list of references separated by commas and enclosed in parentheses e.g.
=FREQUENCY((B5:F50,J5:N50),I5:I16)
Note: the "bins array" can also be a union if required
In "Google sheets" I don't think the same thing is possible - there may be a clever workaround, but I'm not aware of it
这篇关于将两个数据范围合并成一个范围(Google Drive Excel)的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!