Filter Values Between Two Numbers with Excel FILTER
Question details
Return rows where the value in column G is greater than 15 and less than 30.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Use the FILTER function to extract matching rows from columns A through G on the DATA sheet.
- Observed behavior
- The desired result includes only rows with column G values between 15 and 30, excluding both boundaries.
Confirm that the source data is on the DATA sheet in A2:G201 and that column G contains numeric values. Choose an empty output cell with enough space for the filtered results to spill.
Combine Two Conditions in the Excel FILTER Formula
Use this formula to return rows that meet both numeric conditions.
Multiplying the two conditions in the include argument acts as an AND test. The source range and condition ranges must have the same number of rows.
Select an empty cell outside the source range and enter =FILTER(DATA!A2:G201,(DATA!G2:G201>15)*(DATA!G2:G201<30),"No matches").
Press Enter. Excel spills matching rows into the cells below and to the right, or displays No matches if no rows qualify.
To include 15 and 30, edit the formula to =FILTER(DATA!A2:G201,(DATA!G2:G201>=15)*(DATA!G2:G201<=30),"No matches").

Filter Rows Between Two Values in WPS Spreadsheet
Use a FILTER formula in a compatible version of WPS Spreadsheet to extract rows that meet both numeric conditions.
- 1. Open the workbook: Open WPS Spreadsheet, select Open, and choose your Excel workbook.
- 2. Enter the formula: Select an empty cell and enter =FILTER(DATA!A2:G201,(DATA!G2:G201>15)*(DATA!G2:G201<30),"No matches").
- 3. Review and save: Press Enter to display the matching rows, then use File > Save As to save the workbook in XLSX format.

Frequently Asked Questions
How do I include 15 and 30 in the results?
In the FILTER formula, replace >15 with >=15 and <30 with <=30.
What does the asterisk between the conditions do?
In the FILTER include argument, the asterisk combines the tests as an AND condition, so a row must satisfy both.
Why does the formula display No matches?
No rows met both conditions. Check the values in DATA!G2:G201 and confirm that numbers are stored as numeric values rather than text.
Why does Excel show a #SPILL! error?
The output range may be blocked. Clear the cells below and to the right of the formula, then let Excel spill the results.




