TEXTJOIN searching for duplicated inputs and concatenating result in the same cell

Asked

Viewed 28 times

0

I need to show only the domains that a particular account is part of.

I tried a few ways with TEXTJOIN, IF, INDEX, and the most I got was the result below, that it ends up showing the whole array as a result instead of just the domains that this account exists.

On the other hand, the line searching for the user Operator shows nothing as a result:

inserir a descrição da imagem aqui.

Does anyone know how I get this result?

=TEXTJOIN(";"; TRUE; IF(A2:A10=$E$2; B2:B10; ""))
  • I did not understand what is the expected result, could edit with what you want the formula to accomplish?

  • If the admin has more than one domain it will appear where? In column C? In cell B3 and move the rest down?

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.