Slow Sorting

[blandow]

Hi. I have 2 rows of data with 800,000+ records. I need to identify duplicates, then I wanted to highlight them and bring the duplicate records to the top of the row. The built in sorting functions on Excel 2007 are great, but I guess I have too many records, because it would always freeze, and eventually go to not responding mode. I purchased an online tool called "Dupe Wizard" which is a nice tool, but it also freezes the machine. It's just 2 lists of phone numbers, set to "general" formatting, with no spaces or special characters. The pc is a 2ghz w/2gb ram. Any suggestions?

Thanks!

[royUK]

There's no need for using "SLOOOOOW" in your title. We have many non-english speaking members who may not understand & it also makes any solution less likely to appear if someone searhes with a similar problem

[royUK]

Excel 2007 now has a vast amount of rows, but it cannot really work with that amount of data, I figure it's about 12 times previous row limits.

[blandow]

So a better solution would be a custom database program?