Results 1 to 2 of 2

Thread: One to Many lookup, listing of results

  1. #1
    Neophyte crobidoux's Avatar
    Join Date
    Apr 2021
    Posts
    1
    Articles
    0
    Excel Version
    Microsoft Excel for Microsoft

    One to Many lookup, listing of results



    Register for a FREE account, and/
    or Log in to avoid these ads!

    In column c I have used a =countifs to give me the number of occurrances of appeal codes are found in the list on the pivot tab. In column D i want to list those codes. so where the result in column C is 2 I want both codes to be listed in column c. How can I do that. If it can count them, it should be able to list them.
    Attached Files Attached Files

  2. #2
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,940
    Articles
    0
    Excel Version
    365
    See column D of new sheet.
    Attached Files Attached Files

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •