S sj1601 Board Regular Joined Aug 12, 2006 Messages 96 Oct 10, 2006 #1 Hi All, I have two rows of data. In one row there is data duplication (meaning I have say "John Smith" twice). I want to set up a formula to get rid of the duplicates and the data to appear only once. Any suggestions? Thanks.