What is needed here on this one is assuming column A will contain a list of telephone numbers entered in this format: (xxx) yyy-zzzz which is how it would appear in the formula bar if the cell were selected, a macro that would eliminate all duplicates but the most important aspect would be to always retain the first entry of the number in column A and only eliminate any and all subsequent duplicate entries of same numbers.
the final twist if possible, although not critical, would be to show in column C those duplicate numbers that were eliminated from column A when the Macro runs.
the final twist if possible, although not critical, would be to show in column C those duplicate numbers that were eliminated from column A when the Macro runs.