Hello, brand new excel user here:
Currently I am working on a large spreadsheet and working to organize photos and items based on multiple factors. The main factor I am organizing by is simply by numbering the photos and then listing what category they fall into. What I am attempting to do is arrange it so under my "category" column I can enter multiple titles under the same photo number and have one photo filtered into multiple filters.
For example if there a picture of someone running by the ocean and I have two categories, one for pictures by the ocean, and another for pictures of people running, how I could I get the same photo to end up in the two different category filters?
I hope this wasn't too confusing any help would be greatly appreciated, let me know if I need to clarify.
Bookmarks