Closed Thread
Results 1 to 6 of 6

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

  1. #1
    Registered User
    Join Date
    03-22-2015
    Location
    LAs Vegas, NV
    MS-Off Ver
    2010
    Posts
    13

    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


    The answer should be 3

    C20358
    C20449
    C20457
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,430

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

  3. #3
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

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

    I didn't download your file.

    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.
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  4. #4
    Registered User
    Join Date
    03-22-2015
    Location
    LAs Vegas, NV
    MS-Off Ver
    2010
    Posts
    13

    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. #5
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

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

    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.

  6. #6
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    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.

    Thread Closed.

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 07-12-2015, 03:37 PM
  2. [SOLVED] Count Unique Values if Adjacent Cell is Not Blank
    By Dr. D in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-18-2015, 03:05 PM
  3. [SOLVED] Need to Count Blank cells from active cell going UP the same column
    By EDaig in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-15-2013, 11:22 PM
  4. Replies: 2
    Last Post: 10-04-2012, 03:19 PM
  5. total count of non-blank cell(s) and unique values
    By esanchezz in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-09-2010, 01:53 PM

Bookmarks

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