+ Reply to Thread
Results 1 to 2 of 2

Filter with Multiple Pieces of Data in One Column

  1. #1
    Registered User
    Join Date
    01-26-2010
    Location
    LA
    MS-Off Ver
    Excel 2003
    Posts
    16

    Filter with Multiple Pieces of Data in One Column

    Ok, here is my problem. I have a very large database and I need to filter by one specific code(214). The problem is, the code cells can have up to 80 different codes at once. It's not very handy to do 'text to columns' to split these up into 80 different columns, and the code isn't necessarily in the same place in the order of codes. For instance one cell may show: 214, 101, 95, 25 and another cell may show 217, 214, 35, 2

    I don't know if there is an easy way to do this with filter and sorting, or a VBA that would work....any ideas? Thanks!

  2. #2
    Registered User
    Join Date
    08-17-2007
    Posts
    23

    Re: Filter with Multiple Pieces of Data in One Column

    Can you add a column and put the formula

    =IF(ISERROR(FIND("214",A2,1)),"No","Yes")

    So if 214 is in there, then it will return a Yes, if it is not in there it will return a No.

    Change A2, to whatever the first cell you want to check is.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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