index or filter?

M

minnebelle

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
 
D

David Billigmeier

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?
 
M

minnebelle

Great, it worked!

thanks,
sue


David Billigmeier said:
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?
Click to expand...
 
Top