Results 1 to 11 of 11

Count multiple conditions array only works with 1 value

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-25-2013
    Location
    near Philly, PA USA
    MS-Off Ver
    Excel 2019
    Posts
    178

    Count multiple conditions array only works with 1 value

    I have a file (attached) of articles with titles and multiple authors (if more than one contributed to the article).
    I need to count the number of times one author co-authored an article with another author.
    I thought a table/array of all author names vertically as table row names with same names across the top as column labels and the number of times they've co-authored in the cells beneath.

    Perhaps I need a macro (not sure how to do that) but I thought an array formula might work. It works for the first author but not thereafter.
    Suggestions are greatly appreciated!
    Attached Files Attached Files

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