Excel question: I have used the formula in a database =if(d1-d2, 0, 1). I am able to view the duplicates because they are 0's but is there a way to do a mass deletion. But is it possible for it to delete the entire row based upon the zero. The database contains over 10,000 items therefore...