Hi, I'm new to this forum and would like to ask for help on an excel formula. I currently have an excel (example attached) where I have employees name in the first column and job functions in the first row across the top. Next to each employee name, I have entered if they perform that job function, indicated by "Yes". What I would like for the formula to do is reference an employee's name (cell B25 of attached example) and below, list all job functions where "Yes" is indicated. For example: Cornelius Johns (cell B25) would display "Sales" in cell B26.
I have attempted to use an array =IFERROR(INDEX(,SMALL(IF(INDEX(,,MATCH())="Yes" formula, however have been unsuccessful.
Any advice is greatly appreciated
Thank you in advance
Bookmarks