What version of excel are you using?

Mark wrote:

try using the autofilter option on your list of numbers and select the
option to display only unique items. Then you can copy that list.

--

Dave Peterson