Results 1 to 9 of 9

count the number of unique values given certain conditions

Threaded View

  1. #1
    Registered User
    Join Date
    05-31-2012
    Location
    Ohio
    MS-Off Ver
    Excel 2007
    Posts
    3

    count the number of unique values given certain conditions

    I've searched through the forums to see if my question was already out there and i feel that so many posts were so close but i couldn't wrap my head around how to make them work to my situation. I've never used =FREQUENCY or =MATCH formulas so i have no idea how to manipulate them for my needs. (i saw these being used in similar posts).

    here's my specific problem. i need to count the number of unique phone numbers for outbound calls in August by each person. so i have 4 columns of information, 3 columns of criteria, and the 4th column is the list of phone numbers.

    i've attached my sample data with the results i'm looking for and an explanation of the desired results. i hope someone out there gets what i'm trying to do. i hope i was clear enough! fingers crossed that there's a solution.

    Erin
    Attached Files Attached Files
    Last edited by eh308701; 05-31-2012 at 08:34 PM. Reason: misspelled a word wrong in title

Thread Information

Users Browsing this Thread

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

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