A receiving review needs quantities from 16 through 28. Set both limits on the same column so a row has to meet the lower and upper condition.

Apply two conditions to Quantity

Select the data range with headers in Ulet Sheets. Enable Filter in Data → Sort & Filter if needed, then choose Advanced. For Quantity, set “greater than or equal to” 16 and “less than or equal to” 28. Join them with AND and apply.

The condition example sets Quantity to at least 16 and at most 28.

Illustrated filter logic. Both comparisons must apply to the same numeric column.

Try the four boundary rows

Use 15, 16, 28 and 29 in a test copy. Only 16 and 28 should remain visible. If outside values appear, check the join. An OR rule lets 29 pass the lower comparison and 15 pass the upper one.

The boundary test keeps 16 and 28 and excludes 15 and 29.

Illustrated result. Test both included endpoints and one value on each side.

If an in-range value is absent, check the filter range and whether the cell stores a number. Read the full visible record before handing off the review list.