Sort and Match 2 different columns

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. 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

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

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