Forum Discussion
Solved
Need help with my TEXTJOIN Formula
Hi all, I'm new to this forum and i have a question regarding this formula =TEXTVERKETTEN(", "; WAHR; FILTER( 'Training Matrix'!$I$4:$AT$4; // training names ('Internal Tracking'!$A$4:...
The correct formula in F5 is
=TEXTJOIN("; ",TRUE,FILTER('Internal Tracking'!$E$3:$AB$3,ISNUMBER(FILTER('Internal Tracking'!$E$4:$AB$85, 'Internal Tracking'!$A$4:$A$85=$A5, "")), ""))
Auf Deutsch:
=TEXTVERKETTEN("; ";WAHR;FILTER('Internal Tracking'!$E$3:$AB$3;ISTZAHL(FILTER('Internal Tracking'!$E$4:$AB$85; 'Internal Tracking'!$A$4:$A$85=$A5; "")); ""))
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
https://docs.google.com/spreadsheets/d/1k-gIzs91YiNq_MAsPrD4QKyUiglbl11r/edit?usp=sharing&ouid=115058807617085367176&rtpof=true&sd=true here is the sample data, this is my other account as i couldn't share it with my work email, i hope it helps !
The correct formula in F5 is
=TEXTJOIN("; ",TRUE,FILTER('Internal Tracking'!$E$3:$AB$3,ISNUMBER(FILTER('Internal Tracking'!$E$4:$AB$85, 'Internal Tracking'!$A$4:$A$85=$A5, "")), ""))
Auf Deutsch:
=TEXTVERKETTEN("; ";WAHR;FILTER('Internal Tracking'!$E$3:$AB$3;ISTZAHL(FILTER('Internal Tracking'!$E$4:$AB$85; 'Internal Tracking'!$A$4:$A$85=$A5; "")); ""))
thanks!
