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
|