Results 1 to 6 of 6

Count unique values in columns based on 2 criteria

Threaded View

  1. #1
    Registered User
    Join Date
    02-01-2013
    Location
    West Hartford, CT
    MS-Off Ver
    Excel 2013
    Posts
    8

    Count unique values in columns based on 2 criteria

    Excel 2013
    I am trying to calculate the following values. The spreadsheet is attached.

    Unique Emails 7 (formula I am using is below)
    count of phones without emails (answer is 1)
    count of UNIQUE emails without phones answer is 3
    count of UNIQUE emails with phones answer is 4



    Column A Column B
    email@yahoo.com (212) 888-8888
    emailg@gmail.com
    ddd@gmail
    yyyyy@msn.com (203) 555-1212
    yyyyy@msn.com (203) 555-1212
    (312) 888-2222
    gggg@hotmail.com
    gggg@hotmail.com (212) 999-7777
    oooonooo@mail.com
    fffff@right.com (312) 444-2222


    =SUM(IF(FREQUENCY(IF(LEN(A6:A15)>0,MATCH(A6:A15,A6:A15,0),""), IF(LEN(A6:A15)>0,MATCH(A6:A15,A6:A15,0),""))>0,1))
    Attached Files Attached Files
    Last edited by t83357; 08-09-2013 at 10:32 PM. Reason: formatting table looked bad. wrong version of excel listed

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. count unique values of 2 columns with criteria
    By kbalasub in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-16-2013, 12:15 PM
  2. Count unique values across 2 columns with multiple criteria
    By Skywalker01 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-29-2012, 08:04 AM
  3. Count unique values based on several criteria
    By evilgrin in forum Excel General
    Replies: 2
    Last Post: 10-10-2010, 03:50 PM
  4. Count unique values based on matching criteria
    By gromitw in forum Excel General
    Replies: 9
    Last Post: 01-10-2007, 08:59 AM
  5. [SOLVED] how to count unique values in excel based on criteria
    By Jorge in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-13-2005, 10:06 AM

Tags for this Thread

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