I know how to do the data filter [custom/advanced filter]
But for VLOOKUP or INDEX/MATCH purposes how do I find all instances where I am doing a compare string search.
Second question for now:
If I was searching for the string "North" where I have a list of addresses that can be "123 Northshore Drive" or "1A North Avenue" what would be the index/match code for the contained string?
Thank you
But for VLOOKUP or INDEX/MATCH purposes how do I find all instances where I am doing a compare string search.
Second question for now:
If I was searching for the string "North" where I have a list of addresses that can be "123 Northshore Drive" or "1A North Avenue" what would be the index/match code for the contained string?
Thank you