Is there a way to return each unique piece of data from one range to another?

For example if I have a set of data in column G, but I want to know how many
different (or unique) pieces of data are in that column and I want each
different one returned to column M.

Thanks!

Hi,

Select the data in column G then

Data|Filter - Advanced filter

Select 'Copy to another location'
Select 'Unique records only

Select a cell in column M to copy to

OK

Mike

"lightbulb" wrote:

Is there a way to return each unique piece of data from one range to another?

For example if I have a set of data in column G, but I want to know how many
different (or unique) pieces of data are in that column and I want each
different one returned to column M.

Thanks!