How to filter Unique values from Duplicates
On Friday, December 5, 2014 11:59:00 AM UTC+5:30, Claus Busch wrote:
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:
Insert the array formula with CTRL+Shift+Enter and copy down till the
cell remain blank
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional
Thanks Claus.. it worked great!
Could you please explain the steps of this formula