View Single Post
  #7   Report Post  
Old December 5th 14, 09:39 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 1:25:09 PM UTC+5:30, Claus Busch wrote:

Am Thu, 4 Dec 2014 23:23:48 -0800 (PST) schrieb San:

Could you please explain the steps of this formula

with the COUNTIF statement the values existing above the formula will be
ignored. And together with the part A$1:A$500<"" and the Match
statement the next value is found in A:A

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

Thanks for the explanation.