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

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.