Using DCOUNTA to count only Unique values

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.
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting only Unique cells 11
Using (SUM(IF(FREQUENCY....to determine unique values 2
count value dependent on unique or repeated values in another colu 2
Count Unique Values in 1 Column based on Date Range in another Column 28
Count Unique Values 4
count unique values with auto-filter on 6
Excel Pivot Table - Counting Unique Values within one column of da 1
Average Unique 7

Top