Question

fitering of data in a list is done based on​

Answer 1

Answer:

Hi buddy

Explanation:

How do you filter Excel by a list of values?

Run the Advanced Filter

Select a cell in the data table.

On the Data tab of the Ribbon, in the Sort & Filter group, click Advanced.

For Action, select Filter the list, in-place.

For List range, select the data table.

For Criteria range, select C1:C1 – the criteria heading and formula cells.

Click OK, to see the results.

Answer 2

Answer:

Excel Filter to Match List of Items

Excel Filter to Match List of Items

To make it easy to filter for several different items, you create a list of those items on a worksheet. Then, filter your data based on that list, so you don't have to check all the items manually each time.

Two Options for Filtering

Here's the sample data, and the list of items that we want to filter. The table in column F is named tblFind, and cells F2:F3 are named FindList.

advancedfiltercriteria13

We'll look at two options for filtering the list:

Filter rows that have an exact Product match for items in the list

Filter rows that contain an item in the list, anywhere in the Product field