Highlight Duplicate Values without Conditional Formatting

[Krist]

When I format any column of my spreadsheets to highlight duplicate values, my filtering slows to a crawl. It is entirely frustrating!!!!! I noticed the same issue on the last version of Excel and I just got a new HP with the I7 Processor so I don't think it is the computer. Is anyone else having this issue? Granted my spreadsheets can be hundreds of thousands of rows in length, however even when I shorten the rows to 2k I still have the same problem. Is there any better way to highlight duplicate values within a column that will not slow my filtering down??

Thanks!
Kris

[Whizbang]

You could make a macro and run it only when you want to search for duplicates.

The problem with all the non-macro solutions I know of is that it has to evaluate the entire range, for each cell in that range, each time the sheet calculates, which takes some time.

Please Login or Register  to view this content.