Forum Discussion
Excel Crashes on Sorting
Riny_van_Eekelen Thanks for your reply. The file is just 1 MB, but yes, I have applied conditional formatting ('highlight duplicate values') on both columns.
Harman365 That should not be a problem. What if you remove the CF and just sort in whatever order. Better then?
Riny_van_Eekelen It works fine if I sort A-Z after removing the CF. But I need to sort after using conditional formatting to highlight duplicates.
Other solutions (such as only sorting a few hundred rows at a time) do not work. To explain better here's come context:
Column_1 is an old list of items
Column _2 is a new list of items
For any non-duplicates, they are either new entries (and must be tagged as such) or deprecated entires (and must be deleted from record).
P.S. I just shifted to using google sheets for the time being, and they work smoothly with the same data file.