If a column has a value (numeric or text) then show it's corresponding cells in another spreadsheet

huangapple go评论67阅读模式
英文:

If a column has a value (numeric or text) then show it's corresponding cells in another spreadsheet

问题

在第一个电子表格中,如果在列E中存在任何值(无论是数字还是文本),则在另一个电子表格中显示其相应的单元格(即仅显示名称和ID)。

电子表格1:

If a column has a value (numeric or text) then show it's corresponding cells in another spreadsheet

期望的输出在电子表格2中:

If a column has a value (numeric or text) then show it's corresponding cells in another spreadsheet

谢谢。

英文:

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:

If a column has a value (numeric or text) then show it's corresponding cells in another spreadsheet

Desired Output in spreadsheet 2:

If a column has a value (numeric or text) then show it's corresponding cells in another spreadsheet

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&lt;&gt;&quot;&quot;)

Or QUERY() function like-

=QUERY(Sheet1!A:D,&quot;where D is not null&quot;,1)

答案2

得分: 2

=筛选({'表格 1'!D:D, '表格 1'!A:A, '表格 1'!E:E}, '表格 1'!E:E<>"")

英文:

For the ideal output, you may try:

=filter({&#39;Sheet 1&#39;!D:D,&#39;Sheet 1&#39;!A:A ,&#39;Sheet 1&#39;!E:E},&#39;Sheet 1&#39;!E:E&lt;&gt;&quot;&quot;)

huangapple
  • 本文由 发表于 2023年2月19日 15:57:33
  • 转载请务必保留本文链接:https://go.coder-hub.com/75498730.html
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定