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

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

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