如何解决"GTE的数组参数大小不同"的错误? [英] How do I fix error saying “Array arguments to GTE are of different size”?

问题描述

我正在比较一个连续列表，以查看第二个列表中是否存在这些单元格.它作为一个单元格工作，但是当我尝试将其转换为数组时，因为它已连接到表单.关于如何修复或更改代码以使其正常工作的任何线索?初始列表在页面上，但比较列表在单独的称为位置"的工作表中

I'm comparing a continuous list to see if the cells exist within a second list. It works as a single cell, but when I try to convert it to an array because it's connected to a form. Any clue how to fix or change the code to get it to work? The initial list is on the page but the comparison list in on a separate sheet called "Locations"

=ARRAYFORMULA(IF((B100:B)="",,IF(TEXTJOIN(", ", 1, 
 IF((E100:E*1>=Locations!D2:D)*(E100:E*1<=Locations!E2:E)*
    (F100:F*1>=Locations!F$2:F)*(F100:F*1<=Locations!G2:G), Locations!C2:C, ))="", 
 "out of range", TEXTJOIN(", ", 1, 
 IF((E100:E*1>=Locations!D2:D)*(E100:E*1<=Locations!E2:E)*
    (F100:F*1>=Locations!F2:F)*(F100:F*1<=Locations!G2:G), Locations!C2:C, )))))

这是工作表的链接.我假设它不起作用，因为它使用2个differnet数组. 1从位置表中，然后 https://docs.google. com/spreadsheets/d/1OZSDju3hRyGyRfFhHJT2PLQ3DBvcfOAT1ZvNxB-J0DQ/edit?usp = sharing

Here's the link to the sheet. I'm assuming it doesn't work because it uses 2 differnet arrays. 1 from the Locations sheet and https://docs.google.com/spreadsheets/d/1OZSDju3hRyGyRfFhHJT2PLQ3DBvcfOAT1ZvNxB-J0DQ/edit?usp=sharing

推荐答案

GTE代表大于等于，它告诉我比较数组的长度不同. Locations表只有1000行，而VirtualCourseUpload有50,500行.这里有一些可能的解决方案:

GTE stands for Greater-Than-Equal, which tells me that the comparison arrays are of two different lengths. The Locations sheet only has 1000 rows, where as your VirtualCourseUpload has 50,500. Here a couple possible solutions:

• 在Locations的底部添加49500多行以使其起作用(滚动到工作表的底部)，或者
• 使用特定范围限制而不是整个列

• Add 49500 more rows to the bottom of Locations to get it to work (scroll to the bottom of the sheet), or
• Use a specific range limit instead of the whole column

这篇关于如何解决"GTE的数组参数大小不同"的错误?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！