Results 1 to 7 of 7

Align rows comparing multiple columns

Threaded View

cinti07 Align rows comparing multiple... 09-17-2010, 03:21 PM
shg Re: Align rows comparing... 09-17-2010, 05:29 PM
cinti07 Re: Align rows comparing... 09-20-2010, 04:23 PM
shg Re: Align rows comparing... 09-20-2010, 06:25 PM
BCCR Re: Align rows comparing... 01-18-2012, 03:09 PM
jacksage Re: Align rows comparing... 10-13-2012, 03:11 PM
arlu1201 Re: Align rows comparing... 10-15-2012, 06:11 AM
  1. #1
    Registered User
    Join Date
    09-17-2010
    Location
    Cincinnati, USA
    MS-Off Ver
    Excel 2003
    Posts
    2

    Question Align rows comparing multiple columns

    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!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1