View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CLR
 
Posts: n/a
Default Counting unique records

Maybe..........

=SUBTOTAL(3,A:A)

Vaya con Dios,
Chuck, CABGx3



"yhtak" wrote:

I am trying to count unique entries in one filtered column of a multi column,
multi-row spreadsheet. Is this possible? e.g.


872T56OM17
872T56OM17
872T56OH17
etc
etc
(up to 26K rows)
Thanks is advance