How to extract data with specific text?

We can use advance filter to derive the items that contain specific text.In this example, we will use “=Tablets” in Product column. Advance Filter will find all the rows that contain Tablets in Product column.

Following is the picture of specific text criteria
 
img35
 
Press ALT + A + Q for launching advance filter dialog box & follow the below ranges in the fields
 
img36
 
In this example, we will get a list of Product as Tablets.Refer below snapshot for better understanding:
 
img37
 
ADVANCE FILTER INDEX:

Introduction to Advance Filter
1. Using “And”, “Or” and Multiple Criteria
2. How to Filter Unique Records?
3. How to Use Wildcards?
4. Extract records after specific date criteria
5. Extract items between 2 Date’s criteria
6. How to extract data with specific text?
7. How to extract data to another worksheet using VBA?
 

Download E-Book
 
 

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube