software

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 yI want a list:
A
B
C

thanks

In a helper column (i.e. directly to the right of your data) enter this
formula:

=IF(COUNTIF($A$1:A1,A1)gt;1,quot;quot;,A1)

Drag this formula down to the end of your data. Then, copy this range and
do a quot;Paste Specialquot;-gt;Values on your other sheet. Finally, sort this range
to get rid of all the blank spaces in between.

Does that help?
--
Regards,
Davequot;minnebellequot; wrote:

gt; I have a table of sampleIDs and tests. The sampleIDs are in a column and
gt; appear multiple times because there are multiple tests done on each sample. I
gt; want to find and copy a list of unique sampleIDs that have been analyzed on
gt; another sheet.
gt;
gt; table:
gt; sampleID test
gt; A x
gt; B x
gt; B z
gt; A z
gt; C y
gt; C w
gt; B w
gt; A y
gt;
gt;
gt; I want a list:
gt; A
gt; B
gt; C
gt;
gt; thanks

Great, it worked!

thanks,
suequot;David Billigmeierquot; wrote:

gt; In a helper column (i.e. directly to the right of your data) enter this
gt; formula:
gt;
gt; =IF(COUNTIF($A$1:A1,A1)gt;1,quot;quot;,A1)
gt;
gt; Drag this formula down to the end of your data. Then, copy this range and
gt; do a quot;Paste Specialquot;-gt;Values on your other sheet. Finally, sort this range
gt; to get rid of all the blank spaces in between.
gt;
gt; Does that help?
gt; --
gt; Regards,
gt; Dave
gt;
gt;
gt; quot;minnebellequot; wrote:
gt;
gt; gt; I have a table of sampleIDs and tests. The sampleIDs are in a column and
gt; gt; appear multiple times because there are multiple tests done on each sample. I
gt; gt; want to find and copy a list of unique sampleIDs that have been analyzed on
gt; gt; another sheet.
gt; gt;
gt; gt; table:
gt; gt; sampleID test
gt; gt; A x
gt; gt; B x
gt; gt; B z
gt; gt; A z
gt; gt; C y
gt; gt; C w
gt; gt; B w
gt; gt; A y
gt; gt;
gt; gt;
gt; gt; I want a list:
gt; gt; A
gt; gt; B
gt; gt; C
gt; gt;
gt; gt; thanks