Thread: Using DCOUNTA to count only Unique values
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob
 
Posts: n/a
Default Using DCOUNTA to count only Unique values
I have a column containing hundreds of Project Numbers (e.g., P8763, PA3229,
P1090.1, etc.), and the same Project Number can appear more than once in the
column. I need to count the number of unique Project Numbers within that
column. Is there a way to do that? Any help would be greatly appreciated.
Thanks.
Reply With QuoteReply With Quote