Tag Archives: named ranges

Comparing lists in Excel 2011

At work we have a newsletter that we send out three times a year. We send it out in both print and E:Mail. We’re trying to get as many people as possible to switch to the E:Mail edition as this cuts costs, and inbetween issues several people have switched to E:Mail. I wanted to compare the e:mail addresses on our customer database with those in our mailing list software, and add those that did not exist. To do this I used Excel conditional formatting feature to highlight the addresses that only appeared on the customer database and not in the mailing list

Continue reading