FG

Excel 2007: Filtering out rows in a table based on a list

Fresh3 days ago
Mar 15, 202694591 views
Confidence Score0%
0%

Problem

I have a large table that looks like this: I want to selectivley hide rows by populating a list of filterd values. For example, I'd like to filter out (hide) all rows that contain 'ef', 'kl', and 'qr'. Is there an easy way to do this? I know how to use Advanced filters to include only the rows that…

Error Output

ID      String
1       abcde
2       defgh
3       defgh
4       defgh
5       ijkl
6       ijkl
7       mnop
8       qrst

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: Excel 2007: Filtering out rows in a table based on a list

Low Risk

You can still use the Advanced Filters. Here's how you can use it for your problem: Single Criterion Here's a way to exclude or hide cells that contain the substring "ef." Result: This is the formula in A13: which works the same as: Note the usage o…

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment