I want to do a search where I can look up the "street name" out of an address
column. For example, where it says 1708 Augusta Rd, I want to search for all
address on "Augusta" (in case it's Street instead of Road). Does anyone know
how to do this?
I want to do a search where I can look up the "street name" out of an address
column. For example, where it says 1708 Augusta Rd, I want to search for all
address on "Augusta" (in case it's Street instead of Road). Does anyone know
how to do this?
If your data is set up as a table you can use the DATA/AUTOFILTER from the
menu and this run a custom query in the address column using the 'contains'
operator.
--
Kevin Backmann
"T Perry" wrote:
> I want to do a search where I can look up the "street name" out of an address
> column. For example, where it says 1708 Augusta Rd, I want to search for all
> address on "Augusta" (in case it's Street instead of Road). Does anyone know
> how to do this?
Data > Filter > AutoFilter > Custom > Contains > Augusta
Vaya con Dios,
Chuck, CABGx3
"T Perry" wrote:
> I want to do a search where I can look up the "street name" out of an address
> column. For example, where it says 1708 Augusta Rd, I want to search for all
> address on "Augusta" (in case it's Street instead of Road). Does anyone know
> how to do this?
You could have a helper column with -
=IF(ISNUMBER(SEARCH("Augusta",A1)),1,0)
This will return 1 in any row with the target text.
Regards.
Bill Ridgeway
Computer Solutions
"T Perry" <[email protected]> wrote in message
news:[email protected]...
>I want to do a search where I can look up the "street name" out of an
>address
> column. For example, where it says 1708 Augusta Rd, I want to search for
> all
> address on "Augusta" (in case it's Street instead of Road). Does anyone
> know
> how to do this?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks