View Single Post
  #4   Report Post  
Old December 5th 14, 07:28 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 22:22:20 -0800 (PST) schrieb San:

Any other method for e.g. by indexing and finding out duplicates?

your data is in column A. Then e.g. in C1:
in C2:
=IFERROR(INDEX(A:A,MATCH(1,(COUNTIF(C$1:C1,A$1:A$5 00)=0)*(A$1:A$500<""),0)),"")
Insert the array formula with CTRL+Shift+Enter and copy down till the
cell remain blank

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