On Wed, 14 Jul 2010 12:30:20 -0500, Dave Peterson
wrote:

I wouldn't do this.

It may screw up any sorts/filters/charts that you decide you want to use in the
future.

Instead, I'd leave the duplicated values, but hide them using conditional
formatting.

I see you had the same idea I did. Yours was posted first but I
didn't see it until after I had posted mine.