Thread: Duplicates
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Duplicates

I'm not sure why you'd want to give each group a name, but after you've sorted
the data, you could use data|subtotals to make it easier to view the groups.

Pammy wrote:

I have a column with 1721 rows and within this column there are duplicates,
is there a way I can group the duplicates together, I have done a sort, and
grouped them this way, but I would like to give each group a name. I was not
sure if excel will do this. Thanks,


--

Dave Peterson