+ Reply to Thread
Results 1 to 2 of 2

Filtering cells to exclude specific data

  1. #1
    Registered User
    Join Date
    01-31-2014
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    1

    Filtering cells to exclude specific data

    I have a columm that contains combined data of numbers and letters. I want to filter that column to exclude cells that contain the letter "d" or "f". I am trying to create a pivot table from the results of the filter to only display the ID #s that do not contain the letters "f" or "d".
    The data inside the fields is not the same length and is not listed in a particular order. I have over 14,000 records I need to filter.

    Data set example: The items in red are an example of the cells I would like to exclude from my worksheet. Is there a way to filter without deleting the data?

    445-0706634F946
    5886-K949-D001
    445-0716622F946
    445-0706634F887
    497-0480473
    445-9995967F025
    6569-9788-2342
    9016-1300
    9016-C765-875
    123-S765-87645
    Last edited by scorpio31; 01-31-2014 at 11:33 PM.

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: Filtering cells to exclude specific data

    In B2 Cell

    =IF(SUMPRODUCT(1*ISNUMBER(SEARCH({"d","f"},A2))),"De-select","Select")

    Drag it down...

    Refer the attached file to know how to use it with Pivot Table
    Attached Files Attached Files


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

+ 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. Sumifs exclude cells that are hidden with data filter
    By rhyan66 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-18-2013, 10:16 AM
  2. Replies: 0
    Last Post: 10-02-2012, 02:01 AM
  3. Replies: 5
    Last Post: 07-19-2012, 08:18 PM
  4. Counting data in non blank cells and exclude certain data from the count
    By JohnG73 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-04-2007, 04:08 PM
  5. [SOLVED] Filtering a column to exclude any repeated entries.
    By bay in forum Excel General
    Replies: 2
    Last Post: 01-27-2005, 07:06 AM

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