index or filter?

[Guest]

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

 

[Guest]

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?

 

[Guest]

Great, it worked!

thanks,
sue

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?