英文:
If a column has a value (numeric or text) then show it's corresponding cells in another spreadsheet
问题
在第一个电子表格中,如果在列E中存在任何值(无论是数字还是文本),则在另一个电子表格中显示其相应的单元格(即仅显示名称和ID)。
电子表格1:
期望的输出在电子表格2中:
谢谢。
英文:
I have 2 spreadsheets, in the first spreadsheet, in column E, if there is any value present ( whether numeric or text then show its corresponding cells ( i.e only name and ID) in another spreadsheet.
Sheet 1:
Desired Output in spreadsheet 2:
Thank you
答案1
得分: 2
=FILTER()函数。尝试-
=FILTER(Sheet1!A2:D,Sheet1!D2:D<>"")
或者使用QUERY()
函数-
=QUERY(Sheet1!A:D,"where D is not null",1)
英文:
You need FILTER()
function. Try-
=FILTER(Sheet1!A2:D,Sheet1!D2:D<>"")
Or QUERY()
function like-
=QUERY(Sheet1!A:D,"where D is not null",1)
答案2
得分: 2
=筛选({'表格 1'!D:D, '表格 1'!A:A, '表格 1'!E:E}, '表格 1'!E:E<>"")
英文:
For the ideal output, you may try:
=filter({'Sheet 1'!D:D,'Sheet 1'!A:A ,'Sheet 1'!E:E},'Sheet 1'!E:E<>"")
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库,让每个人都能够通过互相帮助和分享经验来进步。
评论