Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
index or filter?
I have a table of sampleIDs and tests. The sampleIDs are in a column and
appear multiple times because there are multiple tests done on each sample. I want to find and copy a list of unique sampleIDs that have been analyzed on another sheet. table: sampleID test A x B x B z A z C y C w B w A y I want a list: A B C thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
index or filter?
In a helper column (i.e. directly to the right of your data) enter this
formula: =IF(COUNTIF($A$1:A1,A1)1,"",A1) Drag this formula down to the end of your data. Then, copy this range and do a "Paste Special"-Values on your other sheet. Finally, sort this range to get rid of all the blank spaces in between. Does that help? -- Regards, Dave "minnebelle" wrote: I have a table of sampleIDs and tests. The sampleIDs are in a column and appear multiple times because there are multiple tests done on each sample. I want to find and copy a list of unique sampleIDs that have been analyzed on another sheet. table: sampleID test A x B x B z A z C y C w B w A y I want a list: A B C thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
index or filter?
Great, it worked!
thanks, sue "David Billigmeier" wrote: In a helper column (i.e. directly to the right of your data) enter this formula: =IF(COUNTIF($A$1:A1,A1)1,"",A1) Drag this formula down to the end of your data. Then, copy this range and do a "Paste Special"-Values on your other sheet. Finally, sort this range to get rid of all the blank spaces in between. Does that help? -- Regards, Dave "minnebelle" wrote: I have a table of sampleIDs and tests. The sampleIDs are in a column and appear multiple times because there are multiple tests done on each sample. I want to find and copy a list of unique sampleIDs that have been analyzed on another sheet. table: sampleID test A x B x B z A z C y C w B w A y I want a list: A B C thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Filter - Protected sheet/workbook | Excel Discussion (Misc queries) | |||
How to make Bullen's FilterCriteria() data refresh real-time? | Excel Discussion (Misc queries) | |||
Filter Switches vs Macro? | Excel Discussion (Misc queries) | |||
advanced filter won't allow me to filter on bracketed text (-456.2 | Excel Discussion (Misc queries) | |||
index to a range of cells | Excel Worksheet Functions |