I have an Excel index to organize information for a collection of photographs. See the attached sample worksheet.
Because one photo may have more than one person in it, I have created multiple columns for their names (Person1, Person2, Person3, etc.)
I want to be able to filter the spreadsheet to display only those rows that contain the name of a particular person. My problem is that the person's name may be located across MULTIPLE possible columns (Person1, Person2, Person3, etc.).
Can the "Advanced Filter" feature be successfully be used for this? If not, is there another way to accomplish this?
THANK YOU!!
Bookmarks