英文:
filter(Importrange) with filter condition on value of cell and not a direct value
问题
我在这个 Google 表格问题上卡住了一段时间。
我的公式在使用单元格的直接值时工作：
working
但是在使用单元格 C2 的引用时不起作用：
not working2
两个图片中的黑色部分是相同的。
我尝试了围绕单元格的 "VALUE()" 进行操作，但也不起作用：
not working
英文:
Got stuck on this GSheets problem for a while.
My formula is working using direct value of a cell :
working
But not working using reference of the cell C2 :
not working2
Parts in black are the same between the two pictures.
I tried working around "VALUE()" of the cell but not working too :
not working
答案1
得分: 0
From your screenshots it looks like the numbers maybe text-based in your source sheet (from where you are importing).
-
在你的源工作表中，使用
ISNUMBER()检查数字是否以文本形式存在。 -
在你的目标工作表中使用以下公式，看看效果如何：
=filter([importrange(x)]; [importrange(x)] = TO_TEXT(C1))
英文:
From your screenshots it looks like the numbers maybe text-based in your source sheet(from where you are importing)
1.check on the numbers in your source sheet using ISNUMBER()
2.use this formula in your destination sheet & see how it goes
=filter([importrange(x)]; [importrange(x)] = TO_TEXT(C1))
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论