# Formulas: Sorting data tables by more than one colu

• 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

abc
213
345
556

I would like to be able to look at the data like this:

abc
x1x
2xx
3x3
x4x
555
xx6

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?

Thanks,
Susan

• one option:

the formula is:

=ISNUMBER(MATCH(\$D2,A\$1:A\$4,0))

• Thank you so much! You have literally saved me 100s of hours of work.

Susan

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!