I am comparing inventory lists from previous year to current year, and I use Excel's conditional formatting to identify duplicate values between two columns of data. Each column contains over 40,000 rows of data. I need to sort the data in column A with unique values at the top. When I attempt to do so, Excel crashes as the sort is too resource-intensive. I need to group all the unique values...
De-dupe large Excel spreadsheet 11 heures left
€66 (Avg Bid)
€66 Offre moyenne