Results 1 to 3 of 3

filter data

Threaded View

  1. 06-30-2017, 02:50 PM #1
    Marwah
    Marwah is offline
    Registered User
    Join Date
    02-26-2017
    Location
    Texas
    MS-Off Ver
    MAC Excel 2016
    Posts
    75

    filter data

    I would like to filter the data according to the following criteria

    First column is as follows for example I have the following barcodes

    TCGA-3C-AAAU-10A-01D-A41E-01

    TCGA-3C-AAAU-01A-11D-A41E-01

    I want only barcode with 01A ( 4th value) not 10A

    I have different barcodes but the 4th value is either 10A,11A or 01A

    I want the ones with 01A

    I have attached sample of the data, I have around 200,000 rows
    Attached Files Attached Files
    Last edited by Marwah; 06-30-2017 at 02:53 PM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA Advanced Filter - Two Filters Without Deleting Bottom Filter Data In Same Column Range
    By hysterical.useless in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-14-2017, 02:54 PM
  2. [SOLVED] Select Automatic Report Filter in Pivot where Filter exist in Data table else select Blank
    By vinaynaran in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-02-2016, 08:47 AM
  3. [SOLVED] Find Count of filter, Advanced filter Data
    By linok in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 01-06-2015, 04:41 AM
  4. Filter data type mismatch? Filter column of numbers from criteria on 2nd sheet w/ wildcard
    By sdl2 in forum Excel General
    Replies: 1
    Last Post: 12-12-2014, 06:46 AM
  5. Using filter with list stored in a column and process data for each filter selection
    By shailew in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-16-2014, 10:55 AM
  6. Filter data and edit with a search istead of the filter button
    By dhamit in forum Excel General
    Replies: 2
    Last Post: 10-07-2013, 04:57 AM
  7. Second Advanced Filter does not work based on the data generated from the filter
    By mucc1928 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-29-2011, 02:42 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1