Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Align two columns of data

  1. #1
    New Member
    Join Date
    Apr 2004
    Location
    Florida
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Align two columns of data

    I have two columns of data of different lengths (more rows in one column). I need to compare the second column to the first and align (by row) similar cells. How can you do this???

  2. #2
    New Member
    Join Date
    Mar 2004
    Location
    London
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Align two columns of data

    Hi There,

    Welcome to the board..

    Copy this into your third column..

    =IF(ISNA(MATCH(B1,$A$1:$A$15,0)),"",B1)

    Paste the shorter list into the first column and then the longer list in the second column.

    You might want to extend the range also ",$A$1:$A$[to last cell of second column],0"..

    Hope this works..

    Have a good weekend..

    Jakob

  3. #3
    New Member
    Join Date
    Sep 2012
    Posts
    28
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Align two columns of data

    Thanks jscholds it worked for me.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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