I have a big table in which one of the columns is titled name. I try to use advanced filter to identify the subjects with the exact same names as those on a name list.
The problem is the advanced filter will pick up, for example, "Chris", "Christian" and "Christina", when the list only has Chris and I don't want to have "Christof", "Christina" or "Christian". Similarly, I want only "Jon" and do not want to have "Jonathan" and "Jonna", for example.
It is said that I can use
="=Chris" in the advanced filter criteria. But this seems to work when there is only a single criterion. Now my criteria is a range of specific names, not a single name. I have tried
but Excel said
the reference isn't valid
How could I set up the advanced filter to find the exact match with a range of criteria ?