“ array_row参数2不匹配的行尺寸”尽管只引用了3行？

发布于 2025-02-10 19:06:55 字数 1035 浏览 2 评论 0原文

我正在使用Google表格，并尝试根据几个基本标准过滤原始数据，同时还将结果插入Col4中的URL创建和COL14中的图像显示（每个基于COL3和COL13中的结果）。

但是，当使用此公式时，如果两个或多个行符合“ Where”标准，则为我提供array_row参数2不匹配的行大小错误。当我四处搜索此错误时，我会看到有关人们参考多个不同行数的多个不同数据集的结果。但是，正如我们在这里看到的那样，我每次仅引用相同的3行。

我是否缺少有关此错误的东西？

=ARRAYFORMULA({
({
QUERY({A4:S6}, "select Col1,Col2,Col3 where Col15 = 'Review' and Col19 >=3",0)
}),({
HYPERLINK(CONCATENATE("http://www.google.com/search?q=",INDIRECT(ADDRESS(ROW(D4),COLUMN(D4)-1))),INDIRECT(ADDRESS(ROW(D4),COLUMN(D4)-1)))
}),({
QUERY({A4:S6}, "select Col5,Col6,Col7,Col8,Col9,Col10,Col11,Col12,Col13 where Col15 = 'Review' and Col19 >=3",0)
}),({
IMAGE(INDIRECT(ADDRESS(ROW(N4),COLUMN(N4)-1)))
}),({
QUERY({A4:S6}, "select Col15,Col16,Col17,Col18 where Col15 = 'Review' and Col19 >=3",0)
  })
})

编辑：这是我要实现的示例表。

原文

I'm using Google Sheets and trying to filter raw data based on a couple of basic criteria, whilst also interjecting the results with URL creation in Col4 and an image display in Col14 (each based on the results in Col3 and Col13).

However, when using this formula, if two or more rows meet the 'where' criteria, I am given a ARRAY_ROW parameter 2 mismatched row size error. When I search around for help with this error, I see lots of results about people referencing multiple different data sets with varying row amounts. But as we can see here, I only reference the same 3 rows each time.

Am I missing something with regards to this error?

=ARRAYFORMULA({
({
QUERY({A4:S6}, "select Col1,Col2,Col3 where Col15 = 'Review' and Col19 >=3",0)
}),({
HYPERLINK(CONCATENATE("http://www.google.com/search?q=",INDIRECT(ADDRESS(ROW(D4),COLUMN(D4)-1))),INDIRECT(ADDRESS(ROW(D4),COLUMN(D4)-1)))
}),({
QUERY({A4:S6}, "select Col5,Col6,Col7,Col8,Col9,Col10,Col11,Col12,Col13 where Col15 = 'Review' and Col19 >=3",0)
}),({
IMAGE(INDIRECT(ADDRESS(ROW(N4),COLUMN(N4)-1)))
}),({
QUERY({A4:S6}, "select Col15,Col16,Col17,Col18 where Col15 = 'Review' and Col19 >=3",0)
  })
})

EDIT: Here's an example sheet of what I'm trying to achieve.
https://docs.google.com/spreadsheets/d/1dwuvK-zxG1dqsWopaWkW69yT2M2dqopCs1sTw0-xNCo/edit?usp=sharing

分享到QQ

分享到微博