View Single Post
  #2   Report Post  
Old December 5th 14, 06:19 AM posted to microsoft.public.excel.worksheet.functions
Claus Busch Claus Busch is offline
external usenet poster
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,832
Default How to filter Unique values from Duplicates


Am Thu, 4 Dec 2014 20:38:04 -0800 (PST) schrieb San:

I have a table where one of the columns contain names of Coalfields but the column contains duplicate names.

I would like to make a separate column containing only unique names of the coalfields, sourced from the mother column.

try Advanced Filter without duplicates or copy your column to another
place and run Delete Dupicates

Claus B.
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional