Results 1 to 8 of 8

Count unique entries across columns based on criteria

Threaded View

  1. #1
    Registered User
    Join Date
    10-16-2012
    Location
    Danmark
    MS-Off Ver
    2010
    Posts
    3

    Count unique entries across columns based on criteria

    I have a table of different trainer names (columns) and training sessions (rows)
    I have formulas to count how many trainers took part in each training session and how many sessions each trainer has been doing.
    Each training session has from 2 to 6 trainers.

    I would now like to count the number of co-trainers each trainer has worked with.
    In the attached example I have counted the Co-trainers manually in row 24. Does anybody know of a formula that can do the counting automatically.
    I prefer not to use VBA.

    Thanks
    Peter
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Count unique values in columns based on 2 criteria
    By t83357 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-12-2013, 04:33 PM
  2. [SOLVED] How can I count line entries based on meeting criteria for 2 separate columns?
    By neilrk7 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-15-2013, 12:57 PM
  3. [SOLVED] Count Unique Pairs of Excel Entries Based on Criteria
    By DonFord81 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-22-2013, 01:12 PM
  4. Count unique entries with criteria
    By Leopold2000 in forum Excel General
    Replies: 9
    Last Post: 12-04-2012, 12:24 AM
  5. count unique entries with criteria
    By shinbar in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-03-2005, 02:31 PM

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