包含特定单词的公式以自动复制和显示单元格

问题描述

我有一个Google表格，用于存储RSS提要(在Sheet1中).我想做的是创建一个公式，该公式将在Sheet2中复制并显示Sheet1中所有包含某些单词的提要.示例屏幕截图:

在此示例中，我想复制并显示(从Sheet1到Sheet2)所有带有单词BLACK和SHIRT的提要，从这里开始，我想自动复制并显示提要，每次它包含这两个单词时

这可能吗?

解决方案

返回包含字符串"black shirt"的行:

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

要返回包含C2:C中列出的所有完整单词的行:

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

查询文档

FILTER文档

I have a Google Sheets where I store RSS feeds (in Sheet1). What I would like to do is to create a formula that will, in Sheet2, copy and display all feeds from Sheet1, which contain certain words. Screenshot of 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?

解决方案

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

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