Range filtering answers a narrower question than sorting: which values fall inside a window you define, not where they rank in the full list.
When a band beats a full sort
You have 200 temperature readings and only care about the ones between 98 and 102. Sorting the whole column still leaves you scrolling for the slice. Draw a single band here and the matching values surface on their own, labeled, ready to copy into a spreadsheet or a report.
Stack multiple bands when the job is tiered. Sales reps often split leads into cold (0–25), warm (26–50), and hot (51+) score buckets. One paste, three labeled outputs, no manual IF formulas in Excel.
Filter vs count: same input, different question
| Task | This tool | Count Numbers in Range |
|---|---|---|
| Primary output | The actual numbers inside each band | How many fall in, below, or above one window |
| Range rows | Multiple labeled bands at once | Single min-max pair |
| Best for | Exporting a subset to another sheet | Quick distribution check on one boundary |
Endpoint inclusion changes edge cases
With endpoints included, a value of exactly 10 lands inside a 10–30 band. Turn endpoints off and 10 sits outside, because the comparison becomes strictly greater than 10 and strictly less than 30. Neither choice is wrong. Pick the one your grading rubric, SLA tier, or sensor spec already uses.
Negative ranges work the same way. A band from -5 to 5 keeps zero when endpoints are on. A band from -10 to -1 never touches positive values regardless of the toggle.
Where multi-band filtering shows up
- Grade bands. Pull every score between 70 and 79 into one list for a remediation email, while 80–89 goes to a separate bucket.
- Inventory thresholds. Flag SKUs with stock between 1 and 10 for reorder, and a second band from 11 to 50 for monitoring only.
- Survey responses. NPS scores of 0–6, 7–8, and 9–10 map to three follow-up workflows. Label each band before you copy.
- Sensor logs. A spike above 85 degrees matters, but so does the cluster between 60 and 70. Two bands, one paste.
What this filter refuses to do
The parser reads integers and decimals separated by commas, spaces, tabs, or line breaks. Tokens like $42.50 or 3,200 trip the comma splitter: the dollar sign drops but the thousands comma splits 3,200 into 3 and 200. Paste plain digits when precision matters.
Overlapping bands without the combine toggle list the same value in every band whose window covers the number. The behavior is deliberate for tier auditing, not a bug. For unique values across all bands, enable Combine all ranges.
Every step runs inside your browser tab. A list with tens of thousands of entries slows the page before the math fails. For parity splits or prime-only subsets, the Even Odd Number Filter or Prime Number Filter fit better than arbitrary min-max windows.
After you extract a subset, Sort Numbers orders the kept values low to high. Remove Duplicate Numbers strips repeats if the source list carried copies. Number List Statistics adds variance and spread once the band is narrow enough to report on.
