I run across this problem all the time, but have never come up with a quick way to compare similar lists on 2 (or more) different worksheets. On the attached, List2 has 3 more rows (exported records) than List1. I know there's gotta be a slick way to have the rows that are unique to each worksheet show up, maybe using conditional formatting? Any advice/tips would be appreciated...
Bookmarks