View Single Post
  #5   Report Post  
Old December 5th 14, 08:23 AM posted to microsoft.public.excel.worksheet.functions
San[_4_] San[_4_] is offline
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2013
Posts: 26
Default How to filter Unique values from Duplicates

On Friday, December 5, 2014 11:59:00 AM UTC+5:30, Claus Busch wrote:
Hi,

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:
=A1
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


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


Thanks Claus.. it worked great!

Could you please explain the steps of this formula

San