{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["ورقة1","Feuil2","BDD"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"ورقة1","index":0,"n_rows":6,"n_cols":1,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["فلترة متقدمة و ترحيل بشرط "]
[]
["https://www.officena.net/ib/topic/114587-فلترة-متقدمة-و-ترحيل-بشرط/#google_vignette"]
[]
["طلب مساعدة في فلترة و ترحيل من الشيت1 الى الشيت 2  القيم الموجودة في الاعمدة,E, F, G A ،C,D"]
["الشرط في الخلية D6"]

{"sheet":"Feuil2","index":1,"n_rows":67,"n_cols":14,"rows_kept":67,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"AA 1"]
[null,null,null,"binome",null,null,null,null,null,null,null,null,null,"AA 2"]
[null,null,null,"AA 1",null,null,null,null,null,null,null,null,null,"AA 3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"AA 4"]
["N","code","NOM","je","gc","hd","nenv",null,null,null,null,null,null,"AA 5"]
[{"$f":"IF(B9<>\"\",ROW()-8,\"\")","v":1},17001,"NOM1",92678,9171,"",15,null,null,null,null,null,null,"AA 6"]
[{"$f":"IF(B10<>\"\",ROW()-8,\"\")","v":2},17022,"NOM22",91229,9137,"",11,null,null,null,null,null,null,"AA 7"]
["",null,null,null,null,null,null,null,null,null,null,null,null,"AA 8"]
["",null,null,null,null,null,null,null,null,null,null,null,null,"AA 9"]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]

{"sheet":"BDD","index":2,"n_rows":26,"n_cols":28,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["N","binome","code","NOM","je","gc","hd","nenv"]
[1,{"$f":"S2&\" \"&T2","v":"AA 1"},17001,"NOM1",92678,9171,{"$f":"IFERROR(VLOOKUP([1]Feuil2!A141,[1]Feuil3!A141:F173,6,FALSE),\"\")","v":""},15,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(AB:AB,2+INT((T2-1)/7))","v":"AA"},1,null,null,null,null,null,null,null,"AA"]
[2,{"$f":"S3&\" \"&T3","v":"AA 2"},17002,"NOM2",92703,9170,null,18,null,null,null,null,null,null,null,null,null,null,"AA",2,null,null,null,null,null,null,null,"AB"]
[3,"AA 3",17003,"NOM3",92579,9137,{"$f":"IFERROR(VLOOKUP([1]Feuil2!A97,[1]Feuil3!A97:F129,6,FALSE),\"\")","v":""},17,null,null,null,null,null,null,null,null,null,null,"AA",3,null,null,null,null,null,null,null,"BC"]
[4,"AA 4",17004,"NOM4",91186,9053,{"$f":"IFERROR(VLOOKUP([1]Feuil2!A52,[1]Feuil3!A52:F84,6,FALSE),\"\")","v":""},22,null,null,null,null,null,null,null,null,null,null,"AA",4]
[5,"AA 5",17005,"NOM5",92616,9164,{"$f":"IFERROR(VLOOKUP([1]Feuil2!A119,[1]Feuil3!A119:F151,6,FALSE),\"\")","v":""},17,null,null,null,null,null,null,null,null,null,null,"AA",5]
[6,"AA 6",17006,"NOM6",91959,9077,{"$f":"IFERROR(VLOOKUP([1]Feuil2!A64,[1]Feuil3!A64:F96,6,FALSE),\"\")","v":""},18,null,null,null,null,null,null,null,null,null,null,"AA",6]
[7,"AA 7",17007,"NOM7",92421,9084,{"$f":"IFERROR(VLOOKUP([1]Feuil2!A67,[1]Feuil3!A67:F99,6,FALSE),\"\")","v":""},21,null,null,null,null,null,null,null,null,null,null,"AA",7]
[null,"AB 8",17008,"NOM8",91261,9142,{"$f":"IFERROR(VLOOKUP([1]Feuil2!A102,[1]Feuil3!A102:F134,6,FALSE),\"\")","v":""},13,null,null,null,null,null,null,null,null,null,null,"AB",8]
[null,"AB 9",17009,"NOM9",91369,9168,{"$f":"IFERROR(VLOOKUP([1]Feuil2!A130,[1]Feuil3!A130:F162,6,FALSE),\"\")","v":""},17,null,null,null,null,null,null,null,null,null,null,"AB",9]
[null,"AB 10",17010,"NOM10",91339,9176,{"$f":"IFERROR(VLOOKUP([1]Feuil2!A148,[1]Feuil3!A148:F180,6,FALSE),\"\")","v":""},9,null,null,null,null,null,null,null,null,null,null,"AB",10]
[null,"AB 11",17011,"NOM11",92674,9169,{"$f":"IFERROR(VLOOKUP([1]Feuil2!A134,[1]Feuil3!A134:F166,6,FALSE),\"\")","v":""},17,null,null,null,null,null,null,null,null,null,null,"AB",11]
[null,"AB 12",17012,"NOM12",92595,9141,{"$f":"IFERROR(VLOOKUP([1]Feuil2!A98,[1]Feuil3!A98:F130,6,FALSE),\"\")","v":""},15,null,null,null,null,null,null,null,null,null,null,"AB",12]
[null,"AB 13",17013,"NOM13",91402,9270,{"$f":"IFERROR(VLOOKUP([1]Feuil2!A153,[1]Feuil3!A153:F185,6,FALSE),\"\")","v":""},15,null,null,null,null,null,null,null,null,null,null,"AB",13]
[null,"AB 14",17014,"NOM14",91282,9168,{"$f":"IFERROR(VLOOKUP([1]Feuil2!A129,[1]Feuil3!A129:F161,6,FALSE),\"\")","v":""},12,null,null,null,null,null,null,null,null,null,null,"AB",14]
[null,"BC 15",17015,"NOM15",91142,9009,{"$f":"IFERROR(VLOOKUP([1]Feuil2!A2,[1]Feuil3!A2:F34,6,FALSE),\"\")","v":""},21,null,null,null,null,null,null,null,null,null,null,"BC",15]
[null,"BC 16",17016,"NOM16",91311,9171,{"$f":"IFERROR(VLOOKUP([1]Feuil2!A140,[1]Feuil3!A140:F172,6,FALSE),\"\")","v":""},11,null,null,null,null,null,null,null,null,null,null,"BC",16]
[null,"BC 17",17017,"NOM17",92637,9172,{"$f":"IFERROR(VLOOKUP([1]Feuil2!A142,[1]Feuil3!A142:F174,6,FALSE),\"\")","v":""},21,null,null,null,null,null,null,null,null,null,null,"BC",17]
[null,"BC 18",17018,"NOM18",92653,9170,{"$f":"IFERROR(VLOOKUP([1]Feuil2!A137,[1]Feuil3!A137:F169,6,FALSE),\"\")","v":""},19,null,null,null,null,null,null,null,null,null,null,"BC",18]
[null,"BC 19",17019,"NOM19",91257,9143,{"$f":"IFERROR(VLOOKUP([1]Feuil2!A104,[1]Feuil3!A104:F136,6,FALSE),\"\")","v":""},15,null,null,null,null,null,null,null,null,null,null,"BC",19]
[null,"BC 20",17020,"NOM20",91162,9029,{"$f":"IFERROR(VLOOKUP([1]Feuil2!A32,[1]Feuil3!A32:F64,6,FALSE),\"\")","v":""},18,null,null,null,null,null,null,null,null,null,null,"BC",20]
[null,"BC 21",17021,"NOM21",91324,9170,{"$f":"IFERROR(VLOOKUP([1]Feuil2!A136,[1]Feuil3!A136:F168,6,FALSE),\"\")","v":""},8,null,null,null,null,null,null,null,null,null,null,"BC",21]
[null,"AA 1",17022,"NOM22",91229,9137,{"$f":"IFERROR(VLOOKUP([1]Feuil2!A96,[1]Feuil3!A96:F128,6,FALSE),\"\")","v":""},11,null,null,null,null,null,null,null,null,null,null,"AA",1]
[null,"AA 2",17023,"NOM23",91979,9097,{"$f":"IFERROR(VLOOKUP([1]Feuil2!A76,[1]Feuil3!A76:F108,6,FALSE),\"\")","v":""},19,null,null,null,null,null,null,null,null,null,null,"AA",2]
[null,"AA 3",17024,"NOM24",91418,9143,{"$f":"IFERROR(VLOOKUP([1]Feuil2!A105,[1]Feuil3!A105:F137,6,FALSE),\"\")","v":""},17,null,null,null,null,null,null,null,null,null,null,"AA",3]
[null,"AA 4",17025,"NOM25",91413,9047,{"$f":"IFERROR(VLOOKUP([1]Feuil2!A47,[1]Feuil3!A47:F79,6,FALSE),\"\")","v":""},19,null,null,null,null,null,null,null,null,null,null,"AA",4]