Perform an advanced filter pasting the results in a different location and
indicate unique records

"office guy10" wrote:

If you have a column of some random, and some repeating values, how can you
have the sheet return to you which values are in the column. For example, if
I have a column of 6 values, two values are 39, two values are 45, and two
values are 34, how can I have excel tell me the values making up the column
are 39, 45, and 34?