I have a list of about 400 last names that I want to use to find in those
names in other lists I have by doing an advanced filter. Many of the names
are only a few letters and if I use them as is, as my criteria list, I get
those names plus any that start with those letters. I know I can format the
names so that it will only pick out the exact name on my list by typing
="="the name". I don't want to do that with all 400 names. How can I format
the first name on the list and copy or drag it down with each row changing to
the name on that row?
Example:
Adam format like this ="=adam"
Gil ="=Gil"
Wood