+ Reply to Thread
Results 1 to 4 of 4

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

  1. 07-12-2015, 02:49 PM #1
    accounting2015
    accounting2015 is offline
    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
    Reply With QuoteRegister To Reply
  2. 07-12-2015, 03:31 PM #2
    HSV
    HSV is offline
    Valued Forum Contributor
    Join Date
    02-12-2011
    Location
    The Netherlands
    MS-Off Ver
    365
    Posts
    818

    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.
    Reply With QuoteRegister To Reply
  3. 07-12-2015, 03:34 PM #3
    Richard Buttrey
    Richard Buttrey is offline
    Forum Moderator - RIP 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.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
    Reply With QuoteRegister To Reply
  4. 07-12-2015, 03:37 PM #4
    Tony Valko
    Tony Valko is offline
    Forum Expert 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

    Duplicate thread:

    https://www.excelforum.com/showthread.php?t=1093229
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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. Forumla to count blank cells in a column when another column in the same row is not blank.
    By purldiver in forum Excel Charting & Pivots
    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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1