Alert for matching cells in single column
Posted by Daniel Lee on February 12, 2002 11:36 AM
I have a number of email lists that I am in charge of managing. It's very easy to export these lists into Excel with the "send to" function of Windows. One of the dreaded tasks though is finding multiple identical email addresses in the list. Sometimes people sign up to be on the same list multiple times without realizing it and the number of email addresses can reach the 1000s. What's the best way to find identical values in a single column and having it alert me to the multiple addresses? In other words, is it possible to have the address that is duplicated copied to another column or highlighted somehow? I have read the discussion board thoroughly and checked the archives. I can't find something that addresses this. Thanks!