+ Reply to Thread
Results 1 to 2 of 2

Attempting to filter text within a cell

  1. #1
    Registered User
    Join Date
    01-07-2021
    Location
    Houston
    MS-Off Ver
    Excel 2016
    Posts
    1

    Angry Attempting to filter text within a cell

    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.

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    18,600

    Re: Attempting to filter text within a cell

    Excel is probably not the best tool to do this. My first choice would be a free app that is specifically for organizing photos. My second choice would be Microsoft Access.

    To use Excel for this, it is very difficult to do the way you are envisioning. You need a different approach. The best way to do this is to have a column of numbers and a column of photo names (not sure how you are doing this--using file names?). Then for every category you want to use for each photo, you use another column to put the photo number and the next column for the category. You will have a row for each category for that photo. This is a database-like approach, which is much better than trying jam multiple bits of data into one cell.

    The example I attached uses Excel Tables, which automatically use the formulas when you type in a new row at the bottom. You may want to google more about tables.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Attempting to combine a sumifs for specific text and date
    By wetgoose69 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-03-2019, 10:09 AM
  2. Replies: 4
    Last Post: 02-14-2017, 06:14 PM
  3. Attempting to auto-populate cells with text and symbols
    By Semilogical in forum Excel General
    Replies: 0
    Last Post: 08-25-2015, 11:47 AM
  4. Replies: 3
    Last Post: 10-01-2014, 08:00 PM
  5. [SOLVED] Using HLOOKUP and attempting to find the 2nd row and one cell over
    By sc0o8i3 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-02-2014, 08:04 AM
  6. [SOLVED] Attempting to define content in cell based on update of other cell in same row.
    By ychartra01 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-04-2013, 07:04 PM
  7. Formula to filter out text in text & numbers in a cell
    By Clueless in UK in forum Excel General
    Replies: 4
    Last Post: 11-24-2011, 07:09 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1