# Count only unique cells in column where another cell in row is not blank

1. ## Count only unique cells in column where another cell in row is not blank

I want to count the unique cells in Column A That have a number in Column C

A B C D
C20358 Carriage House; The 479220 \$84.11
C20449 Historic Tamarack Lodge 481341 \$29.97
C20449 Historic Tamarack Lodge 520668 \$9.54
C20457 Old Forge Camping Resort 480541 \$176.04

C20358
C20449
C20457

2. ## Re: Count only unique cells in column where another cell in row is not blank

with a pivot table.

youre file is to big to post.

3. ## Re: Count only unique cells in column where another cell in row is not blank

Data Range
 A B C D E F 1 ------ ------ ------ ------ ------ ------ 2 C20358 Carriage House; The 479220 \$84.11 Unique Count 3 C20449 Historic Tamarack Lodge 481341 \$29.97 3 4 C20449 Historic Tamarack Lodge 520668 \$9.54 5 C20457 Old Forge Camping Resort 480541 \$176.04

This array formula** entered in F3:

=SUM(IF(FREQUENCY(IF(ISNUMBER(C2:C5),MATCH(A2:A5,A2:A5,0)),ROW(A2:A5)-ROW(A2)+1),1))

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

4. ## Re: Count only unique cells in column where another cell in row is not blank

Thank you Tony that was perfect. You guys are awesome.

5. ## Re: Count only unique cells in column where another cell in row is not blank

You're welcome. Thanks for the feedback!

In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.

6. ## Re: Count only unique cells in column where another cell in row is not blank

Somewhat late but note this is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1