title: Comparing two colums using excel while the workbook keeps freezing
body: <p>I'm trying to make comparison between two columns. column A has about 85,000 list and column B has about 270,000. I tried using vlookup and other functions like countif. however, anytime I try any of these functions my excel workbook could take about 45 minutes to an hour to even complete a basic task. please, any suggestion why my excel workbook keeps freezing and slowing down? thanks in advance.</p>