+ Reply to Thread
Results 1 to 2 of 2

Sort and Match 2 different columns

  1. #1
    Registered User
    Join Date
    01-26-2015
    Location
    ohio
    MS-Off Ver
    Excel 2013
    Posts
    1

    Sort and Match 2 different columns

    Hypothetically-- lets say you had column A with 500 rows of 7 digit numbers and column b of 700 rows of 7 digit numbers... is there a way to match columns for identical numbers and then sort to have the ones that match line up? I have this scenario with 30 other columns of data but I need to cut it down to only those that matched in the other column. Thanks!

  2. #2
    Valued Forum Contributor
    Join Date
    12-28-2014
    Location
    NSW, Australia
    MS-Off Ver
    2016
    Posts
    536

    Re: Sort and Match 2 different columns

    Probably not the best way to do it, but I'd have two helper columns for each column you want to check.
    If I wanted to know which numbers in column B existed in column A, then:
    In cell C1 I'd have =IFERROR(IF(MATCH(B1,A:A,0)>0,ROW(),""),"") copied down the same number of rows that are in column B
    And cell D1 I'd have =IFERROR(INDIRECT("B"&SMALL(C:C,ROW())),"") copied down for at least the amount of possible matches

+ 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. Replies: 1
    Last Post: 11-06-2012, 07:07 PM
  2. How to sort & match 2 columns?
    By wearwestern in forum Excel General
    Replies: 2
    Last Post: 10-24-2012, 02:39 PM
  3. Replies: 3
    Last Post: 02-27-2009, 10:56 AM
  4. Match and Sort two columns
    By szu604 in forum Excel General
    Replies: 1
    Last Post: 10-03-2008, 08:12 PM
  5. Replies: 9
    Last Post: 07-02-2008, 06:16 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