Results 1 to 4 of 4

Count without duplicates based on multiple criteria from different cells

Threaded View

  1. #1
    Registered User
    Join Date
    11-30-2011
    Location
    Sactown
    MS-Off Ver
    Excel 2007
    Posts
    6

    Count without duplicates based on multiple criteria from different cells

    I am hoping some genius on this forum can figure this out for me.

    I am trying to create a summary sheet based on many factors on the main spreadsheet. I want a count of all "Contacts" (column E) for the month (column A) and eliminate any duplicate's based on the Par# (column C)

    On the Summary Tab I have already got a count of all contacts for each month based on the criteria with duplicates. I also need a count based on only unique ID#'s/month.

    Draft stat sheet.xlsx
    I attached the Spreadsheet for your review.

    Thanks.
    Last edited by perryadam; 04-22-2013 at 11:12 PM.

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