+ Reply to Thread
Results 1 to 4 of 4

Count multiple conditions array only worked with 1 value

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

    Count multiple conditions array only worked with 1 value

    I tried to use an array formula but it doesn't work and I think I need a macro.

    I have a file (attached) listing journal 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.
    My spreadsheet has a table/array of all author names vertically as table row names with same names across the top as column labels and faux numbers of times they've co-authored in the cells beneath as an example of output.

    My problem is: how to count the # of times each author co-authors with another author.
    The output is in the "table/array" starting on B1040 using the data from above in rows 2 to 29 (actual file goes to 1038 rows).
    Updated sample file attached with a few cells of data entered in the cells to the right of row B31.

    I don't know how to examine the title field to see if it is the same for the author(s) listed and then add to their respective count cells in the table.
    I assume
    Please Login or Register  to view this content.
    will be needed (but that's the easy part!).

    I appreciate the help!
    Bob
    Attached Files Attached Files

  2. #2
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Count multiple conditions array only worked with 1 value

    Hi bob33

    See if the Code in the attached does as you require.
    Attached Files Attached Files
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

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

    Re: Count multiple conditions array only worked with 1 value

    Jaslake,
    Thank you!!
    It seems to work fine on the sample.
    I'll have to integrate it into the actual data file that has over 1000 rows.
    I very much appreciate your assistance and taking the time out of your day to help.
    Best regards,
    Bob

  4. #4
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Count multiple conditions array only worked with 1 value

    You're welcome...glad I could help. Thanks for the Rep.

+ Reply to Thread

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