I have a problem with data manipulation, adn I was wondering if someone could help me. I am running different samples on a mass spectrometer, and I get output lists of masses of different peaks. Some of the peaks are in common, others are unique to a particular sample. For example, if I have 3 samples (a,b,c), I might get the following data
I would like to be able to look at the data like this:
Which shows that 3 is in a and c, 5 is in all three samples, and 1,2,4 and 6 are unique to b,a,b,and c, respectively. (Preferably, the x's are blank cells)
In my data sets, a,b and c do not contain 3 numbers each, but over 100 (and I have 50 + files to compare this way), so I would *really* like to have a formula/macro to perform this sort so I won't have to insert blank cells until the rows line up properly. Is it possible for excel to do this, or do I need to switch to another program?