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.
|
Nou pe simpatie:
barbyDana la Simpatie.ro
 | Femeie
25 ani
Bacau
cauta Barbat
28 - 46 ani |
|
|
Mrrrr's Forum (VIEW ONLY)ReguliInregistrareLoginPozeNu sunteti logat. Lista Forumurilor Pe Tematici
|
| #1 |
TRaPModerator
Postari: 960
|
|
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:
https://www.extendoffice.com/documents/ ... teria.html
|
|
| |
|
| #2 |
|
|
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.
_______________________________________
|
|
| |
|
