重要条件 [英] IMPORTRANGE with condition
本文介绍了重要条件的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我希望在同一文档中使用带有条件的IMPORTRANGE将数据从一个工作表导入到另一个工作表.
Using Google Sheets I want, within the same document, to import data from one sheet to another using IMPORTRANGE with conditions.
我尝试失败:
=IF(IMPORTRANGE("https:URL","Inc Database!B2:B300")="permanent",IMPORTRANGE("htps://URL","Inc Database!A2:A300"),"")
和
=QUERY(IMPORTRANGE("https:/URL", "Inc Database!A2:A300"),"SELECT Col1 WHERE Col1 <> 'permanent'")
和
=FILTER(IMPORTRANGE("URL","Inc Database!A1:A250"),IMPORTRANGE("URL","Inc Database!B1:B250"="venture permanent"))
我希望函数说:从范围A中导入满足范围B中永久"标准的任何值.
I want the function to say: Import any values from range A that meet criterion "permanent" in range B.
A | B
_________|_________
Name |type
---------|-------
Henry |Permanent
William |Intern
John |Permanent
推荐答案
我在电子表格之后:
例如= QUERY(IMPORTRANGE(" https://docs.google.com/电子表格/d/1LX7JfbGvgBTfmXsYZz0u5J7K0O6oHJSnBowKQJGa9lY/edit#gid = 0 ," Inc Database!A2:B300)," SELECT Col1 WHERE not(Col2 ='Permanent'))
e.g. =QUERY(IMPORTRANGE("https://docs.google.com/spreadsheets/d/1LX7JfbGvgBTfmXsYZz0u5J7K0O6oHJSnBowKQJGa9lY/edit#gid=0", "Inc Database!A2:B300"),"SELECT Col1 WHERE not(Col2 = 'Permanent') ")
这篇关于重要条件的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文