Using DCOUNTA to count only Unique values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Just a point of clarification:
The reason I need to use DCOUNTA is because the column of Project Numbers is
part of a database, and I need to use Criteria from other columns within the
database.
 
Back
Top