Results 1 to 4 of 4

Count Unique text based on multiple conditions

Threaded View

  1. #1
    Registered User
    Join Date
    10-13-2003
    Posts
    27

    Count Unique text based on multiple conditions

    I'm not sure this is even possible, but here's what I am trying to do. I want to count the number of unique occurrences based on multiple criteria


    Name Title Task Week Hours
    Joe Smith Manager Meetings 5/13/05 50.00
    Jane Doe Assistant Meetings 5/13/05 10.00
    Jane Doe Assistant Administration 5/13/05 30.00
    Jenny Dee Assistant Meetings 5/13/05 00.00
    Jim Jones Assistant Work Papers 5/13/05 20.00

    What I want to do here is return the unique count of "Assistants" that booked "Hours" for "Week" 5/13/05. The answer is 2

    Any help would be greatly appreciated!
    Thanks,
    Max
    Last edited by MAX258; 05-13-2005 at 12:02 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