+ Reply to Thread
Results 1 to 2 of 2

how to subset rows in data according to column values

  1. #1
    Registered User
    Join Date
    02-26-2017
    Location
    Texas
    MS-Off Ver
    MAC Excel 2016
    Posts
    75

    how to subset rows in data according to column values

    Hello

    I have the attached data I want to subset the data according to the following column "sample" values

    "TCGA.E9.A22E" , "TCGA.AO.A0J5" , "TCGA.A2.A4S1",
    "TCGA.LL.A440" ,"TCGA.AC.A2QJ" , "TCGA.AN.A03X",
    "TCGA.AN.A0XN", "TCGA.BH.A6R9", "TCGA.E9.A1NF",
    "TCGA.BH.A1FH" , "TCGA.EW.A2FR" ,"TCGA.AR.A2LQ" ,
    "TCGA.AC.A23G" ,"TCGA.BH.A0AZ" , "TCGA.AN.A0FN" ,
    "TCGA.A2.A0CZ", "TCGA.A1.A0SH" , "TCGA.AC.A7VC" ,
    "TCGA.BH.A0DI" , "TCGA.A1.A0SI" , "TCGA.BH.A208" ,
    "TCGA.BH.A0H7"

    so I want the data set for just the above values
    Attached Files Attached Files
    Last edited by Marwah; 05-16-2017 at 07:21 PM.

  2. #2
    Forum Expert p24leclerc's Avatar
    Join Date
    07-05-2010
    Location
    Québec
    MS-Off Ver
    Excel 2021
    Posts
    2,081

    Re: how to subset rows in data according to column values

    in the following macro, you just have to put all of your specific sample values into the array and run the macro.
    Please Login or Register  to view this content.
    You may have to set the range to your data if they have changed.
    Pierre Leclerc
    _______________________________________________________

    If you like the help you got,
    Click on the STAR "Add reputation" icon at the bottom.

+ 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. [SOLVED] Creating subset of data based on parameters on a column
    By PBlasdel in forum Excel General
    Replies: 6
    Last Post: 07-25-2014, 11:13 AM
  2. column data to rows for unique values
    By Ray789 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-01-2011, 08:57 PM
  3. Replies: 4
    Last Post: 09-21-2011, 07:20 PM
  4. Replies: 1
    Last Post: 03-15-2011, 11:16 AM
  5. MAX Value of Column Subset
    By WeatherGuy in forum Excel General
    Replies: 5
    Last Post: 04-19-2007, 04:36 PM
  6. [SOLVED] Importing data from several fles with different subset of rows
    By slashenbern@gmail.com in forum Excel General
    Replies: 1
    Last Post: 02-28-2006, 01:30 PM
  7. How to enter symbols for subset or element of a subset in Excel?
    By rwcita in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-23-2006, 05:30 PM

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