B
Beep
I have a list of names approximately 250 rows long in column A. For the most
part, they are in the format of [last_name, first_name + middle_initial]...
all in one cell. I can modify that, if necessary. Perhaps with a text to
columns function.
I downloaded a database from the tax department containing rows of data of
parcel owners. The owners names are contained in the following fashion: their
last names are in column A, their first and middle initials are contained in
column B. As I mentioned above, I can get my sheet set up like the first one,
or the database set up like my list. It would probably make more sense to
make the database look like my list... you think?
I would like to match my list of names up to the tax database and omit all
the other rows whose names don't match up to my list. If I had to end up with
some duplicate matches, I will be okay.
For example, if I have "Williams, Joseph A" in my list and it creates a list
of 4 matches, such as "Williams, Andrew B", "Williams, Calvin C", "Williams,
Mike P" and "Williams, Seth W"; I am okay with that. I would rather have some
non-exact matches, than to omit something I wanted to keep. So, in other
words, I would at least like to filter out the tax database of any names it
contains that don't match up with any last name in my list.
I appreciate any help that someone may offer. If you need further
clarification of what I am trying to accomplish.
part, they are in the format of [last_name, first_name + middle_initial]...
all in one cell. I can modify that, if necessary. Perhaps with a text to
columns function.
I downloaded a database from the tax department containing rows of data of
parcel owners. The owners names are contained in the following fashion: their
last names are in column A, their first and middle initials are contained in
column B. As I mentioned above, I can get my sheet set up like the first one,
or the database set up like my list. It would probably make more sense to
make the database look like my list... you think?
I would like to match my list of names up to the tax database and omit all
the other rows whose names don't match up to my list. If I had to end up with
some duplicate matches, I will be okay.
For example, if I have "Williams, Joseph A" in my list and it creates a list
of 4 matches, such as "Williams, Andrew B", "Williams, Calvin C", "Williams,
Mike P" and "Williams, Seth W"; I am okay with that. I would rather have some
non-exact matches, than to omit something I wanted to keep. So, in other
words, I would at least like to filter out the tax database of any names it
contains that don't match up with any last name in my list.
I appreciate any help that someone may offer. If you need further
clarification of what I am trying to accomplish.