+ Reply to Thread
Results 1 to 9 of 9

Match and align data in 2 columns

  1. #1
    Registered User
    Join Date
    04-02-2014
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    6

    Match and align data in 2 columns

    SO I have 2 columns of account #'s Column C has 98,000, a list of all accounts ever created. Column A has only 60,000 accounts consisting of ONLY the accounts that have been active in the last 5 years.
    I want to Match the values in Column A to the Values in Column C and Do one of 2 things.

    1) Preferably, have Column A Sort to Mach Column C and move that number to the adjacent cell in column A. if there is no Match then just leave the cell in that ROW blank.
    or
    2)Sort and match placing the value in Column B if there is a match somewhere between the two columns if no Match then the cell in that row would just be blank


    Column A Column B Column C

    663695 453942
    514549 449234
    169486 495180


    Please and Thank You

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Match and align data in 2 columns

    Still using Excel 2010?

    This will require VBA - shall I move the thread for you?
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    04-02-2014
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Match and align data in 2 columns

    Thank You for your reply. Well I did it the other day with I think VLOOKUP and IFERROR but forgot to bookmark the video where I finally found it. I haven't used VBA for anything but I am certainly wiling to try.

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Match and align data in 2 columns

    YOu can do the match, but you cannot MOVE data with a formula. What you have described is not simply a match.

  5. #5
    Registered User
    Join Date
    04-02-2014
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Match and align data in 2 columns

    So how can I do it in VBA

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Match and align data in 2 columns

    Let me move the thread then one of the VBA experts will take over. I don't do VBA myself - sorry.

  7. #7
    Registered User
    Join Date
    04-02-2014
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Match and align data in 2 columns

    OK, That will be fine I suppose, Thank You

  8. #8
    Registered User
    Join Date
    04-02-2014
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Match and align data in 2 columns

    Where can I find replies at

  9. #9
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Match and align data in 2 columns

    Here - but there are none yet. Please wait patiently.

+ 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. Match and align columns
    By Jmac1983 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-23-2014, 04:38 PM
  2. [SOLVED] Match, align, find sum for columns
    By madisoned in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-12-2013, 11:00 AM
  3. Need to compare 2 columns and align them next to the match
    By naenightlucky213 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 05-09-2013, 06:14 AM
  4. [SOLVED] Match and Align two columns of data?
    By Erik Thomas in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-08-2012, 07:24 PM
  5. match and align cells in two columns?
    By Timski in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-22-2010, 12:27 PM
  6. Match and Sort and Align two columns
    By szu604 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-03-2008, 02:08 AM

Tags for this Thread

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