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: bruneta_ta_us la Simpatie.ro
| Femeie 25 ani Giurgiu cauta Barbat 25 - 52 ani |
|
Mrrrr
AdMiN
Inregistrat: acum 17 ani
Postari: 2189
|
|
In AA1 I have the value to look for, in AA2 (and dragged down) I put the following Array (CTRL+SHIFT+ENTER) formula:
=INDEX('[DOCUMENTNAME.xlsx]Sheet2'!$A$2:$A$145372;SMALL(IF($AA$1='[DOCUMENTNAME.xlsx]Sheet2'!$J$2:$J$145372;ROW('[DOCUMENTNAME.xlsx]Sheet2'!$J$2:$J$145372)-ROW('[DOCUMENTNAME.xlsx]Sheet2'!$J$2)+1);ROW('[DOCUMENTNAME.xlsx]Sheet2'!1:1)))
Since it looks in over 100k rows, it will take a little to load (10-15 seconds).
Note: Said document.xlsx should be stored in the Documents folder (Start Menu - Documents)
_______________________________________
|
|
pus acum 6 ani |
|