Hey,
I am working on an excel spreadsheet that contains over 200.000 rows (so a huge workbook).
I am trying to highlight and extract instances where the same event has been recorded more than once, but excel keeps crashing when i try. I have used conditional formatting, which results in the whole sheet moving extremely slow. When I try to filter by colour while using conditional formatting, excel keeps crashing! I can't even get the filter dropdown menu to appear. On the few instances it has appeared, it crashes when I select filter by colour.
I then tried the countif()>1 method, which captures rows that are not duplicate values, and leaves out entries that are duplicates. Is there a way to extract my duplicate values from a sheet this big, other than the two routes explained above? My laptop runs on an intel Core i5 vPro processor, and has 4 gb ram. I don't know what to do, please help!!
Bookmarks