将两个数据范围合并为一个范围(Google Drive Excel) [英] Combine two data ranges into one range (Google Drive Excel)
问题描述
您好,我希望将两个数据范围/数组合并为一个,以便将它们输入到 excel FREQUENCY
函数中.
Hi there I am looking to combine two data ranges/arrays into one in order to feed them into excel FREQUENCY
function.
示例:第一个数据范围 - B5:F50
第二个数据范围 - J5:N50
Bins 数据范围 - I5:I16
函数定义 - FREQUENCY(data_array; bins_array)
Example:
First data range - B5:F50
Second data range - J5:N50
Bins data range - I5:I16
Function definition - FREQUENCY(data_array; bins_array)
基本上我很懒,我不想重新调整我的 excel 脚本来并排吐出两个数据集,以便我可以使用 B5:K50
范围之类的东西来引用它们.有什么方法可以使用某种公式将两个数据集组合到 data_array
中?也许最终会得到类似 =FREQUENCY((B5:F50,J5:N50); I5:I16)
的东西?
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)
?
顺便说一句:任何一个
=FREQUENCY(B5:F50; I5:I16)
=FREQUENCY(J5:N50; I5:I16)
工作只是为我自己归档.
work just file on their own for me.
更新
实际公式定义FREQUENCY(data, classes)
2013 MS Excel(无关)
推荐答案
在 MS Excel 中 FREQUENCY
函数接受 "union" 作为第一个参数,即一个列表用逗号分隔并用括号括起来的引用例如
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)
注意:如果需要,bins 数组"也可以是联合体
Note: the "bins array" can also be a union if required
在Google 表格"中,我认为不可能有同样的事情 - 可能有一个聪明的解决方法,但我不知道
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屋!