I have a master spreadsheet with names addresses and phone numbers that I need to filer by zip codes that are within a specific radius of a zip code.
Please change your title, if you mean “filter” instead of filer
… and description.
Guessing an answer:
To hide the rows that fall outside the specific radius:
- While the cursor is in the data range, choose menu
Standard Filter…(all contiguous cells with data will be selected).
- Add Filter Criteria, and
To continue working with all data, press
* of the numeric pad; the same that to choose menu
Select Data Area), and Show Rows.
Tested with LibreOffice 220.127.116.11 (x64); OS: Windows 10.0.
Add Answer is reserved for solutions. If you think the answer is not satisfactory, add a comment below, or click edit (below your question) to add more information. Thanks.
Check the mark ( → ) to the left of the answer that solves your question.
If the answer helped you, you can mark the up arrow () that is on the left (to vote, you need to have karma of at least 5).