Hi,
I have two large data sets that I'm trying to combine (see attached example-Sheet1). The first data set contains a sample name with an associated value and s.d.. The second data set is a subset of the first where some of the samples have other data associated with it multiple times. What I'm trying to do is end up with a worksheet (Sheet2) where I have removed data that is not in both sets and also aligned the data. In addition, I want to add a new column that gives me the number of data points for each sample in the second set. Any ideas?
Thanks.
Bookmarks