按多个值过滤 [英] Filter by multiple values

问题描述

为了解释我想要做什么，我将展示一个更简单的电子表格版本：

我希望能够使用列的多个值过滤器可用。

过滤标记以过滤列>

例如，如果我选择可用的过滤器 e 和 d ，我将只收回15,15和17行。

我的问题是我不知道如何选择我想要的过滤器并过滤表格。

完美的解决方案是使用如下图所示的复选框列表：

但不是在此列中显示确切的值，它应该显示o在筛选器可用表中，并在筛选后显示包含至少一个选定选项的行...

您是否认为我的问题清晰明了？

解决方案

数据透视表。

突出显示您要使用的数据，然后从数据菜单中选择数据透视表。 然后添加字段选择您之后的行和列，并在Filter域中包含要过滤的列。

然后，您可以使用内置的数据透视表过滤器来显示你在追求什么。

显示如何设置和使用的巨型图片谷歌表中的一个数据透视表

这里是链接到谷歌帮助如何创建数据透视表：

链接到Google帮助教程，了解如何使用数据透视表 p>

To explain what I want to do, I will show a much simpler version of my spreadsheet:

I want to be able to filter the Tags to filter column using multiple value of the column Filters available.

For instance, if I select the filters available e and d, I will get back only the lines 15,15 and 17.

My problem is that I don't know how to select the filters that I want and filter the table.

The perfect solution would be to have a list with checkboxes like the one shown in the following picture:

But instead of showing the exact values in this column, it should show the ones in the Filters available table, and after it would filter to show the lines that contains at least one of the options selected...

Do you think I made my question clear?

解决方案

A very easy way of doing this it to use a Pivot Table.

Highlight the data you want to use, then select Pivot Table from the Data menu.

Then Add field to select the Rows and Columns you are after, and include the column you want to filter by in the Filter field

Then you can use the built in Pivot Table Filter to show what you are after.

Giant image showing how to setup and use a pivot table in google sheets

here is a link to the google help for how to create a pivot table:

Link to google help tutorial for how to use pivot tables

这篇关于按多个值过滤的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！