Hi,

Is there a way to make a macro that removes duplicates from any table, based on a single column? Say that the column header is "MyColumn". Basically what I do right now is drill into a bunch of pivots all the time and end up removing duplicates to get isolated values for "MyColumn". I still want that message to pop up that says "10 duplicate values removed; 5 values still remain" or whatever it says.

Any help would be much appreciated!

Thanks.