Im trying to create a list of names from a range based on two variables, while also eliminating duplicate results or blank spaces. For example, if i want to know who has apples OR oranges:
Huey Apples
Dewey Pears
Louie Oranges
Should return:
Huey
Louie
I think a INDEX MATCH in combination with an if/or should work, but I can't seem to put it together correctly....
Thanks!
Bookmarks