Need help Matching numbers

[vatsk]

I have a very large file with two columns with about 40,000 rows, is there an excel formula to match the same numbers in column A to the same numbers in column B and all the other non matching numbers to be pushed to the bottom of the columns?? please help me

 

[vatsk]

Thanks all of you, but im still can get this to work, let me explain in more detail...... I have two columns... column A and column B... in column A has about 10,000 rows and B there are about 40,000 rows...... what i am looking to do is match the numbers in column A to the numbers in column B, and there is only one match per number however the are just by sorting them does not get me a matching list because the number i looking for are all seprate out with different numbers between them for example..... im looking in column A i have number 55 but in coloum B i have 30, 31 32 33 34 all the way up to 55 so i have to manually go through the 10,000 and detele the numbers between the numbers i need to match..... is there some kind of formula to help me detlete the numbers that dont match or push them to the bottom on the excel spread sheet or im i stuck doing this the manual way? p.s. it take me about 3 hours to do can you help me please!!!! thanks.

 

[alanjp]

Vatsk
Col1 Col2 Col 3
1 0 =if(col1=col2,1,0)
1 1 copy formulae down
1 2
1 3
2 1

Sort by Col3 (descending), Col1 (ascending)

Result all matches will be listed and then sorted in numeric order.

You can now delete all rows where Col3 = 0

This is a cheap and nasty approach, but will do the job.

Alan