I created a data based worksheet a few years ago, we are now approaching 10,000 rows and "Ctrl +f " is no longer feasible to find anything, mainly because of Identical street numbers and misspelled words over the years.
I am thinking of a filter to find items, but only from a partial criteria IE:
Filter for addresses that start with the number 100
or
Find addresses that start with the number 100 & street letter starts with c
ie:100 c
lower or upper caps
maybe to make the filter better use 100 ca if the 2nd letter is "a"
Here is a filter code, I don't know what to add to use partial criteria
Bookmarks