How to Create a List Based on Criteria in Excel

To create a list based on criteria in Excel, you can use the FILTER function, which is available in Excel 365 and Excel 2019. This function allows you to filter a range of data based on specific criteria.

Here's how to create a list based on criteria in Excel using the FILTER function:

1. Open your Excel workbook and locate the data you want to filter.
2. Click on an empty cell where you want the filtered list to appear.
3. Type the FILTER function in the following format: =FILTER(range, condition, [empty_message]).

• range: The range of cells you want to filter.
• condition: The criteria that must be met for a row to be included in the filtered list.
• empty_message: (Optional) A message to display if no rows meet the criteria.

4. Press Enter, and Excel will display the filtered list based on your criteria.

Example: FILTER Function to Create a List Based on Criteria

Let's say you have a list of sales data, and you want to create a list of sales that are greater than $1,000. Here is how to use the FILTER function to achieve this:

1. Open your Excel workbook and locate the sales data. For this example, let's assume the data is in the range A1:B10, with column A containing the sales IDs and column B containing the sales amounts.
2. Click on an empty cell where you want the filtered list to appear, for example, cell D1.
3. Type the FILTER function: =FILTER(A1:B10, B1:B10 > 1000, "No sales greater than $1,000").
4. Press Enter, and Excel will display the filtered list of sales greater than $1,000 in column D.

This example demonstrates how to use the FILTER function to create a list based on criteria in Excel. In this case, we filtered the sales data to display only sales greater than $1,000.