Results 1 to 7 of 7

Count unique records for a specific date

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    06-16-2006
    Location
    Sydney, Australia
    MS-Off Ver
    2013 64bit
    Posts
    1,394

    Count unique records for a specific date

    I have a table in a sheet and I want a formula that will count the unique records. The simplified database is as follows (in a table):

    Date	Job#	Item
    1-Feb	10	material
    1-Feb	10	parts
    1-Feb	10	labour
    1-Feb	11	labour
    2-Feb	12	parts
    2-Feb	12	material
    2-Feb	13	labour
    2-Feb	14	labour
    As you can see, on the 1-Feb, there are 4 records, but only 2 unique job numbers. There are 3 unique numbers on 2-Feb.

    So I would like a forumula that will count the unique numbers in the job# column for a set date. I would have thought sumproduct could do it, but I haven't had any luck. I am open to any suggestion that can return an answer in a cell (ie I don't want to use a pivot table or summarise the table etc).
    Last edited by Mallycat; 02-20-2010 at 08:48 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