+ Reply to Thread
Results 1 to 4 of 4

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

    Sample - Data Set.zip

    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

  2. #2
    Valued Forum Contributor
    Join Date
    02-12-2011
    Location
    The Netherlands
    MS-Off Ver
    365
    Posts
    792

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

    Hello,


    Would this the result you expect?
    PHP Code: 
    =SUMPRODUCT(1/COUNTIF(A2:A54,A2:A54&"")*(C2:C54>0)) 
    Kind regards, Harry.

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

    Hi,

    Maybe

    Formula: copy to clipboard
    Please Login or Register  to view this content.

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

    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [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
  2. [SOLVED] Assigning a unique value to all blank cells in a column
    By mohammedfaizal in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-14-2013, 09:41 AM
  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