Align rows comparing multiple columns

**cinti07** · 09-17-2010, 03:21 PM

Hi,

I need to know if there is a way to align rows from multiple columns in excel. I have attached a sample spreadsheet if it helps to understand my question. Column A is my standard data (these are masses of peptides), Column B, C and D are experimental masses that I have from three experiments. I need to treat these questions routinely but I am frustrated to have to do this manually. I need your input and help.

I have read some post regarding this similar question, but mine is even more challenging: you probably already noticed that all my numbers have four decimal points so there is actually no identical numbers in any of the columns/rows. I need to align those numbers within a certain mass range: +/-0.2000 (ideal condition) to my standard data. And all of the columns have different number of rows.

Could someone tell me whether the task is possible by running a Macro? If so, how to solve?

Thanks a lot!

**shg** · 09-17-2010, 05:29 PM

Welcome to the forum.

So the results should look, in part, like this?

Please Login or Register  to view this content.

**cinti07** · 09-20-2010, 04:23 PM

Thanks, shg.

Yes, I wanted to align my data like what you showed (partly). Is there a macro to perform this function?

Thanks!

**shg** · 09-20-2010, 06:25 PM

Unzip the attachment and put it in the desktop (or elsewhere).

Open the workbook and drag it into the VBA project.

For the example you posted, select A1:D1, and in the Names box (left of the formula bar) enter keys

Run macro AlignKeys.

**BCCR** · 01-18-2012, 03:09 PM

Thanks SHG you have saved me hours of work!

**jacksage** · 10-13-2012, 03:11 PM

will this "alignkeys" work with Excel 2010? is this the correct macro for waht I need to accomplish? see attachment sample.lots of data to to align....help is appreciated

I am attaching a sample of what i need to accomplish.data question.xlsx

**arlu1201** · 10-15-2012, 06:11 AM

jacksage,

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.