Forum Discussion
Solved
Multiple Answers for Unique Value
Hi. I have multiple skill assigned for every extension in the contact center. Need assistance on formula to have all the extensions to which the skills has been mapped. Attached workbook with Maste...
Another variant is with Power Query, steps as in attached
Please try this Array Formula which requires confirmation with Ctrl+Shift+Enter instead of Enter alone.
On Answer Sheet,
In B2
=IFERROR(INDEX(Master!$A$2:$A$25,SMALL(IF(Master!$B$2:$D$25=$A2,ROW(Master!$A$2:$A$25)-ROW(Master!$A$2)+1),COLUMNS($B2:B2))),"")and then copy it across and down.