I use this in G: =TEXTJOIN(", "; 1; IF(ISNUMBER(MATCH(A1:F1; {1;2;3;4;5;6}; 0)); A1:F1; ""))
to compare numbers in A:F with numbers in H:M. But even uf there is same numbers in both I get a blank G. What am I doing wrong
Hello
I dont see any reference to H:M
may you attach an example.ods with data in A1:M1 and below the result you would expect from your Formula… use the ⇑.button to upload your example.ods
Provides NO usefull Information!
Let me try to guess.
Formulas should be entered as array formulas, meaning enter the formula text and press Ctrl + Shift + Enter.
1 Like