Forum Discussion

Copper Contributor

May 03, 2019

Help with functions

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 inp...

EXAMPLE.xlsx788 KB

excel

Formulas and Functions

SergeiBaklan

Diamond Contributor

May 03, 2019

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]],"")),"")

EXAMPLE (2) (1).xlsx19 KB

MJShepherd1
Copper Contributor
May 24, 2019
SergeiBaklan 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.
- SergeiBaklan
  Diamond Contributor
  May 24, 2019
  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.