View Single Post
  #6   Report Post  
Old December 5th 14, 08:55 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 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