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:
bruneta99 Profile
 | Femeie
25 ani
Satu Mare
cauta Barbat
25 - 50 ani |
|
|
TRaP
Moderator
Inregistrat: acum 6 ani
Postari: 739
|
|
ARRAY formula (CTRL+SHIFT+ENTER) - insert in cell E2
=INDEX($B$2:$B$17; MATCH(0; IF($D$2=$A$2:$A$17; COUNTIF($E$1:$E1; $B$2:$B$17); ""); 0))
where:
- $B$2:$B$17 contains the values you want to return
- $D$2 contains the criteria (condition) to be met
- $A$2:$A$17 contains the range where the criteria can be found
- $E$1:$E1 is the column where you want your unique matches to appear, assuming E1 contains the table header
Drag down to extract all the unique values from $B$2:$B$17 with criteria.
Source:
|
|
| pus acum 3 ani |
|
Mrrrr
AdMiN
 Inregistrat: acum 17 ani
Postari: 2186
|
|
You can drag this across multiple columns (assuming you have the matches on row 1 as the table header):
=IFERROR(INDEX(Crafting!$B$2:$B$82; MATCH(0; IF(C$1=Crafting!$A$2:$A$82; COUNTIF(C$1:C1; Crafting!$B$2:$B$82); ""); 0));"")
Drag right, then down.
_______________________________________
|
|
| pus acum 2 ani |
|