Simpatie.ro - matrimoniale
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:
Elena01 la Simpatie.ro
Femeie
25 ani
Braila
cauta Barbat
28 - 40 ani
Mrrrr's Forum (VIEW ONLY)ReguliInregistrareLoginPozeNu sunteti logat. Lista Forumurilor Pe Tematici
Mrrrr's Forum (VIEW ONLY) / Tutoriale si Ghiduri Utile // Tutorials and useful guides /

[EXCEL] Using FILTER with Spill Condition

Pagini: 1 Moderat de TRaP, TonyTzu
#1
TRaP
Moderator
Postari: 960
You can't just do the following cause it returns #N/A! error.

=FILTER(Table12;Table12[Document material]=AQ9#)


Solution:

=FILTER(
  Table12;
  ISNUMBER(MATCH(Table12[Document material]; AP9#; 0))
)


 
   
Pagini: 1  
Mergi la