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
The answer should be 3
C20358
C20449
C20457
with a pivot table.
youre file is to big to post.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
I didn't download your file.
Data Range
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.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Thank you Tony that was perfect. You guys are awesome.
You're welcome. Thanks for the feedback!
If your question has been solved please mark the thread as being solved.
In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.
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.
Thread Closed.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks