Google Docs公式自动复制并显示单元格，如果包含特定的单词 [英] Google Docs formula auto copy and display cell if contain a specific word

问题描述

我有一个Google文档电子表格，用于存储rss供稿（在Sheet1中）。我想要做的是创建公式，这将在Sheet2中复制并显示来自Sheet1的所有提要，其中包含某些单词。为了更清楚起见，我准备了一个例子的屏幕截图。在这个例子中，我想复制和显示（从Sheet1到Sheet2）所有提供BLACK和SHIRT字样的提要，并且从这里开始，我想自动复制并显示提要，每次它将包含这两个单词。这是可能的和如何？感谢您的帮助！

解决方案

要返回包含字符串'black shirt'的行：

$ b

要返回包含C2：C中列出的任何完整单词的行：
$ b

= FILTER（Sheet1！B2：B; MMULT SEARCH（TRANSPOSE（& C2：C&）;& Sheet1！B2：B&）; SIGN（ROW（Sheet1！B2：B））））

QUERY文档

FILTER文档

电子表格示例

I have a Google Docs spreadsheet, where I store rss feeds (in Sheet1). What I would like to do is to create formula, which will, in Sheet2, copy and display all feeds from Sheet1, which contains certain words. To be more clear, I prepared a screen shot of an example. In this example I would like to copy and display (from Sheet1 to Sheet2) all feeds with the words BLACK and SHIRT, and from here on I would like to auto copy and display feed, every time it will contain this two words. Is this possible and how? Thank you for your help!

解决方案

To return rows that contain the string 'black shirt':

=QUERY(Sheet1!B:B;"select * where B contains 'black shirt'";1)

To return rows that contain any complete words listed in C2:C:

=FILTER(Sheet1!B2:B;MMULT(SEARCH(TRANSPOSE(" "&C2:C&" ");" "&Sheet1!B2:B&" ");SIGN(ROW(Sheet1!B2:B))))

QUERY documentation

FILTER documentation

Example spreadsheet

这篇关于Google Docs公式自动复制并显示单元格，如果包含特定的单词的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！