Google工作表-显示数据到另一个选项卡如果存在

Question

在Google Sheets Tab One中我有数据

• Apple | 1 | Eat
• Apple | 2 | Don't Eat
• 香蕉| 1 |吃

我想从任何带有"Apple"的行中提取所有数据转到另一个选项卡。选项卡2将显示:

• Apple | 1 | Eat

• Apple | 2 | Don't Eat

我也希望这工作自动，如果我添加以下行Tab 1:

• Apple | 3 | Eat

所以如果Tab 1有:

• Apple | 1 | Eat

• Apple | 2 | Don't Eat

• Apple | 3 | Eat

• 香蕉| 1 |吃

选项卡2自动具有:

• Apple | 1 | Eat

• Apple | 2 | Don't Eat

• Apple | 3 | Eat

谢谢你的帮助!

Answer 1

您可以在第二个选项卡的第一个单元格上使用Query:

= QUERY(TabOne!A:C, "select A, B, C where A = 'Apple'")