Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.
|
Lista Forumurilor Pe Tematici
|
Mrrrr's Forum (VIEW ONLY) | Reguli | Inregistrare | Login
POZE MRRRR'S FORUM (VIEW ONLY)
Nu sunteti logat.
|
Nou pe simpatie:
anamaria
 | Femeie
19 ani
Timis
cauta Barbat
30 - 42 ani |
|
|
TRaP
Moderator
Inregistrat: acum 6 ani
Postari: 787
|
|
Note: For this you need to install the free function add-on for Excel called MOREFUNC:
So I need to look for a string in 2 different columns and concatenate everything I find for that string from 2 other columns.
I have MATERIAL in A:A, and STRING to look for in E:E
I have GROUP in I:I, and STRING to look for in M:M
STRING is the same, only I have to look in 2 different columns for return values (MATERIAL & GROUP). It could as well have been 2 different sheets of data, but I put my tables in the same sheet to reduce the length of the formula.
Here it goes (ARRAY formula, enter with CTRL+SHIFT+ENTER):
="Group: "&SUBSTITUTE(MCONCAT(IF(M:M=A2;"; "&I:I;""));";";"";1)&" // Material: "&SUBSTITUTE(MCONCAT(IF(E:E=A2;"; "&A:A;""));";";"";1)
This concatenates in 1 cell whatever values in columns I:I (GROUP) and A:A (MATERIAL) on the row that matches the value in A2 in columns M:M and E:E.
Source:
|
|
| pus acum 6 ani |
|