Goal: given two lists of sequences, find the things that appear in both lists.
Methods: primer prospector filtered a list of potential primers down to the ones least likely to form secondary structure. Based on this list of 217 'good' primers, we needed to make a list of which wells those primers are in. So how do we compare these two lists?
In Excel 2013, the list of 'good' primers was added of the column containing all primers.
This column was selected then
home > conditional formatting > highlight cell rules > duplicate values
all columns with data were selected then
data > filter
In the column with barcodes, the drop-down box in the top cell was clicked then
filter > by color > cell color > (choose color from)
Results: This produces a list of barcodes which are identified as 'good' by primer prospector with their identifying plate number and position for easy access.
See also: Find duplicate values fast by applying conditional formatting
1 hour
No comments:
Post a Comment