+ Reply to Thread
Results 1 to 1 of 1

Align into columns similar values from adjacent rows in size order ascending from L to R

  1. #1
    Registered User
    Join Date
    07-24-2013
    Location
    England
    MS-Off Ver
    Excel 2003
    Posts
    1

    Align into columns similar values from adjacent rows in size order ascending from L to R

    I am a novice Excel user who doesn't know how to write macros and was hoping some kind person might help me perform the following. I have attached a .xls file to illustrate what I'm trying to do. In the attached file I have headings at the top: 'Number', 'sample name' etc. I then have two sets of three rows. The set at the top is my data before what I need to do to it, and the set below is the data after I have manually aligned the numbers. I would like to be able to run a macro or something so that Excel will do this alignment for me.

    I have three rows, each with two numberical values for 'size', and each value for 'size' has a corresponding value for 'height' and 'peak area' - so each row has 6 values in total. I need to align the values according to size, ascending from left to right. You will notice that the values I have aligned are not exactly the same but differ by <1. I need Excel to consider the numbers the same (and therefore align them) so long as they differ by no more than 0.6.

    If someone can help me with this that would be fantastic!
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Align Rows based on Matching Values in 2 Columns
    By cmv040 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-05-2016, 07:49 PM
  2. Excel 2007 : Align rows by matching values in other columns
    By jhanson60 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-14-2014, 11:27 PM
  3. How to select two columns of values and sort them into ascending order,but w/o moving them
    By jonathancook in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-10-2013, 05:51 PM
  4. Formula to align two columns with nearly similar text and attached numeric columns
    By Benefits Recon in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-27-2012, 12:03 AM
  5. FIND FORMULA SIMILAR TO VLOOKUP FOR NON-ASCENDING VALUES
    By Kir in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-10-2005, 05:45 PM

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