Here are two methods to filter data based on error values in Excel:

Method 1: Using Advanced Filter

1. Select your data range: Highlight the entire table or data set you want to filter.
2. Go to Data > Advanced Filter: Navigate to the "Data" tab and locate the "Advanced Filter" option within the "Data Tools" group.
3. Copy data to a new location (Optional): If you want the filtered results in a separate location, check the box next to "Copy to another location." Then, specify the destination range where you want the filtered data to appear.
4. Criteria range setup: In the "Criteria range" section, you'll need to create a small criteria table with one row and two columns.
- Column 1 Header: In the first cell (let's say B1), type a header like "Error Check."
- Column 1 Formula: In the second cell (B2), enter the formula to identify the error value(s) you want to filter for. Here are some options:
- For all errors: `=ISERROR(A1)` (Replace A1 with your actual data cell reference)
- For specific error value (e.g., #VALUE): `=A1=#VALUE!` (Replace A1 with your data cell reference)
5. Copy formula down (Optional): If you want to filter for multiple error types, copy the formula in cell B2 down to additional rows in your criteria range, entering the specific error value for each row you copied.
6. Click OK: Once your criteria are set, click the "OK" button.

Method 2: Using AutoFilter with Custom Criteria

1. Select your data range: Highlight the entire table or data set you want to filter.
2. Activate the Filter dropdown: Click on the filter arrow in the header row of the column you want to filter by (usually containing the error values).
3. Select "Number Filters" > "Custom Filter": In the dropdown menu, navigate to "Number Filters" and then choose "Custom Filter."
4. Set up criteria: In the pop-up window, select the option "Equals" from the first dropdown menu.
5. Enter formula: In the text box next to "Equals," enter the formula to identify the error value(s). You can use the same formulas mentioned in method 1 (e.g., `=ISERROR(A1)`).
6. Click OK: Click "OK" to apply the filter.

Both methods will display only the rows containing the specified error value(s) in your chosen data range. You can adjust the formulas based on the specific error types you want to filter for.