Help with functions

Copper Contributor

I have attached an example of my SS. I am looking at a way to input a CONFIG item listed in the left-hand column and have it list all of the users who support that configuration.  So if I were to input AMB in a cell it would look at the row with AMB in it and return all the users in the top row who have an X in the AMB row. 

3 Replies

@MJShepherd , if TEXTJOIN is avilable for your version of Excel, you may use it

=IFERROR(TEXTJOIN(",",TRUE,IF(INDEX(Table1[[JB]:[DP]],MATCH(A2,TRIM(Table1[CONFIG]),0),0)="X",Table1[[#Headers],[JB]:[DP]],"")),"")

 

@Sergei Baklan  Thank you this works very well for me, however, when I sent it to my team the function did not work for them. I am missing something. 

@MJShepherd1 , perhaps they are on Excel versions for which function is not available. You may check here https://support.office.com/en-us/article/textjoin-function-357b449a-ec91-49d0-80c3-0e8fc845691c where it shall be.