Hi folks - been lurking here anonymously a while.
Gotta stumper I can't see solved anywhere else.
Trying to filter out any address line 1 values in this spreadsheet that DON'T begin with a street number (for obvious reasons - they're bogus/unusable)/
I tried adding a multi-row advanced filter criteria set to exclude any value that doesn't begin with 1, 2, 3, 4, 5, 6, 7 or 9:
<>1*
<>2*
<>3*
etc.
Weird results - one criteria (e.g. just the <>1* works fine).
Trying to use all 9 criteria does nothing.
Here's the file
data_test.xls
Help?
Bookmarks