Re: find duplicates with Vba when cells have more than 255 characters
Both of these are working with my initial test sheet. Thank you very much PCI and Jindon!
While I like the fact that Jindon's code gives different colors to make it easy to identify different sets of duplicates, this will be run on some massive workbooks that would have the potential to get really crazy looking. So I think I'll use PCI's solution initially.
Thanks again guys!