There are many number filters that you can use in Excel – such as less than/greater than, equal/does not equal, between, top 10, above or below average, etc.
One way to get around this is to create a copy of the data in another worksheet and delete the rows in the copied data. Note that when you delete a row, anything that you may have in other cells in these rows will be lost. Once you have the text based on which you want to filter, hit the Enter key. In case you have a lot of categories/regions, you can type the name in the field right above the box (that has these region names), and Excel will show you only those records that match entered text (as shown below). In the above example, I had only four distinct regions and I could manually select and deselect it from the Filter list (in steps 5 above).