One to Many lookup, listing of results

crobidoux

New member
Joined
Apr 22, 2021
Messages
1
Reaction score
0
Points
0
Excel Version(s)
Microsoft Excel for Microsoft
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.
 

Attachments

  • one to many lookup.xlsx
    450.2 KB · Views: 7
See column D of new sheet.
 

Attachments

  • ExcelGuru11137one to many lookup.xlsx
    477 KB · Views: 12
Back
Top