Home > Software design >  My QUERY ARRAYFORMULA TEXTJOIN sheet doesn't show result as expected
My QUERY ARRAYFORMULA TEXTJOIN sheet doesn't show result as expected

Time:07-19

I want to extract data from Column C (which contains about 1200 rows of numbers) that isn't appear inside Column B into Column E. So far i tried QUERY MATCHES and combined it with TEXTJOIN but it returned nothing. I also tried .* symbol but also doesn't work.

I'm not sure if it's because the TEXTJOIN returned result is too long. But i tried the formula in another cell and it seems to worked fine, so i have no idea why it doesn't work. Here's enter image description here

  • Related