{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["ورقة1","استعلام"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"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":18,"n_cols":7,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,"المطلوب الاستعلام عن الطلاب حسب الصف فى ورقة اخرى بواسطة دالة"]
[null,"جدول الطلاب"]
[]
["الكود","الاسم","الصف","الشعبة"]
[101,"احمد1",1,7]
[103,"احمد3",1,9]
[105,"محمد1",1,9]
[110,"عادل1",1,5]
[102,"احمد2",2,7]
[106,"محمد2",2,8]
[111,"عادل2",2,9]
[104,"احمد4",3,4]
[107,"محمد3",3,5]
[109,"عبده",3,4]
[108,"محمد4",4,4]
[112,"خالد",4,4]
[113,"حسام",5,5]

{"sheet":"استعلام","index":1,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[null,"الصف",1]
[]
["ت","الاسم","الصف","الشعبة"]
[{"$f":"IF(B4=\"\",\"\",SUBTOTAL(3,$B$4:B4))","v":1},{"$f":"IFERROR(INDEX(ورقة1!$B$6:$B$100,SMALL(IF(ورقة1!$C$6:$C$100=$C$1,ROW($A$6:$A$100)-ROW($A$6)+1),ROWS($B$4:B4))),\"\")","v":"احمد1"},{"$f":"IFERROR(INDEX(ورقة1!$C$6:$C$100,SMALL(IF(ورقة1!$C$6:$C$100=$C$1,ROW($A$6:$A$100)-ROW($A$6)+1),ROWS($B$4:C4))),\"\")","v":1},{"$f":"IFERROR(INDEX(ورقة1!$D$6:$D$100,SMALL(IF(ورقة1!$C$6:$C$100=$C$1,ROW($A$6:$A$100)-ROW($A$6)+1),ROWS($B$4:D4))),\"\")","v":7}]
[{"$f":"IF(B5=\"\",\"\",SUBTOTAL(3,$B$4:B5))","v":2},{"$f":"IFERROR(INDEX(ورقة1!$B$6:$B$100,SMALL(IF(ورقة1!$C$6:$C$100=$C$1,ROW($A$6:$A$100)-ROW($A$6)+1),ROWS($B$4:B5))),\"\")","v":"احمد3"},{"$f":"IFERROR(INDEX(ورقة1!$C$6:$C$100,SMALL(IF(ورقة1!$C$6:$C$100=$C$1,ROW($A$6:$A$100)-ROW($A$6)+1),ROWS($B$4:C5))),\"\")","v":1},{"$f":"IFERROR(INDEX(ورقة1!$D$6:$D$100,SMALL(IF(ورقة1!$C$6:$C$100=$C$1,ROW($A$6:$A$100)-ROW($A$6)+1),ROWS($B$4:D5))),\"\")","v":9}]
[{"$f":"IF(B6=\"\",\"\",SUBTOTAL(3,$B$4:B6))","v":3},{"$f":"IFERROR(INDEX(ورقة1!$B$6:$B$100,SMALL(IF(ورقة1!$C$6:$C$100=$C$1,ROW($A$6:$A$100)-ROW($A$6)+1),ROWS($B$4:B6))),\"\")","v":"محمد1"},{"$f":"IFERROR(INDEX(ورقة1!$C$6:$C$100,SMALL(IF(ورقة1!$C$6:$C$100=$C$1,ROW($A$6:$A$100)-ROW($A$6)+1),ROWS($B$4:C6))),\"\")","v":1},{"$f":"IFERROR(INDEX(ورقة1!$D$6:$D$100,SMALL(IF(ورقة1!$C$6:$C$100=$C$1,ROW($A$6:$A$100)-ROW($A$6)+1),ROWS($B$4:D6))),\"\")","v":9}]
[{"$f":"IF(B7=\"\",\"\",SUBTOTAL(3,$B$4:B7))","v":4},{"$f":"IFERROR(INDEX(ورقة1!$B$6:$B$100,SMALL(IF(ورقة1!$C$6:$C$100=$C$1,ROW($A$6:$A$100)-ROW($A$6)+1),ROWS($B$4:B7))),\"\")","v":"عادل1"},{"$f":"IFERROR(INDEX(ورقة1!$C$6:$C$100,SMALL(IF(ورقة1!$C$6:$C$100=$C$1,ROW($A$6:$A$100)-ROW($A$6)+1),ROWS($B$4:C7))),\"\")","v":1},{"$f":"IFERROR(INDEX(ورقة1!$D$6:$D$100,SMALL(IF(ورقة1!$C$6:$C$100=$C$1,ROW($A$6:$A$100)-ROW($A$6)+1),ROWS($B$4:D7))),\"\")","v":5}]
[{"$f":"IF(B8=\"\",\"\",SUBTOTAL(3,$B$4:B8))","v":""},{"$f":"IFERROR(INDEX(ورقة1!$B$6:$B$100,SMALL(IF(ورقة1!$C$6:$C$100=$C$1,ROW($A$6:$A$100)-ROW($A$6)+1),ROWS($B$4:B8))),\"\")","v":""},{"$f":"IFERROR(INDEX(ورقة1!$C$6:$C$100,SMALL(IF(ورقة1!$C$6:$C$100=$C$1,ROW($A$6:$A$100)-ROW($A$6)+1),ROWS($B$4:C8))),\"\")","v":""},{"$f":"IFERROR(INDEX(ورقة1!$D$6:$D$100,SMALL(IF(ورقة1!$C$6:$C$100=$C$1,ROW($A$6:$A$100)-ROW($A$6)+1),ROWS($B$4:D8))),\"\")","v":""}]
[{"$f":"IF(B9=\"\",\"\",SUBTOTAL(3,$B$4:B9))","v":""},{"$f":"IFERROR(INDEX(ورقة1!$B$6:$B$100,SMALL(IF(ورقة1!$C$6:$C$100=$C$1,ROW($A$6:$A$100)-ROW($A$6)+1),ROWS($B$4:B9))),\"\")","v":""},{"$f":"IFERROR(INDEX(ورقة1!$C$6:$C$100,SMALL(IF(ورقة1!$C$6:$C$100=$C$1,ROW($A$6:$A$100)-ROW($A$6)+1),ROWS($B$4:C9))),\"\")","v":""},{"$f":"IFERROR(INDEX(ورقة1!$D$6:$D$100,SMALL(IF(ورقة1!$C$6:$C$100=$C$1,ROW($A$6:$A$100)-ROW($A$6)+1),ROWS($B$4:D9))),\"\")","v":""}]
[{"$f":"IF(B10=\"\",\"\",SUBTOTAL(3,$B$4:B10))","v":""},{"$f":"IFERROR(INDEX(ورقة1!$B$6:$B$100,SMALL(IF(ورقة1!$C$6:$C$100=$C$1,ROW($A$6:$A$100)-ROW($A$6)+1),ROWS($B$4:B10))),\"\")","v":""},{"$f":"IFERROR(INDEX(ورقة1!$C$6:$C$100,SMALL(IF(ورقة1!$C$6:$C$100=$C$1,ROW($A$6:$A$100)-ROW($A$6)+1),ROWS($B$4:C10))),\"\")","v":""},{"$f":"IFERROR(INDEX(ورقة1!$D$6:$D$100,SMALL(IF(ورقة1!$C$6:$C$100=$C$1,ROW($A$6:$A$100)-ROW($A$6)+1),ROWS($B$4:D10))),\"\")","v":""}]
[{"$f":"IF(B11=\"\",\"\",SUBTOTAL(3,$B$4:B11))","v":""},{"$f":"IFERROR(INDEX(ورقة1!$B$6:$B$100,SMALL(IF(ورقة1!$C$6:$C$100=$C$1,ROW($A$6:$A$100)-ROW($A$6)+1),ROWS($B$4:B11))),\"\")","v":""},{"$f":"IFERROR(INDEX(ورقة1!$C$6:$C$100,SMALL(IF(ورقة1!$C$6:$C$100=$C$1,ROW($A$6:$A$100)-ROW($A$6)+1),ROWS($B$4:C11))),\"\")","v":""},{"$f":"IFERROR(INDEX(ورقة1!$D$6:$D$100,SMALL(IF(ورقة1!$C$6:$C$100=$C$1,ROW($A$6:$A$100)-ROW($A$6)+1),ROWS($B$4:D11))),\"\")","v":""}]
[{"$f":"IF(B12=\"\",\"\",SUBTOTAL(3,$B$4:B12))","v":""},{"$f":"IFERROR(INDEX(ورقة1!$B$6:$B$100,SMALL(IF(ورقة1!$C$6:$C$100=$C$1,ROW($A$6:$A$100)-ROW($A$6)+1),ROWS($B$4:B12))),\"\")","v":""},{"$f":"IFERROR(INDEX(ورقة1!$C$6:$C$100,SMALL(IF(ورقة1!$C$6:$C$100=$C$1,ROW($A$6:$A$100)-ROW($A$6)+1),ROWS($B$4:C12))),\"\")","v":""},{"$f":"IFERROR(INDEX(ورقة1!$D$6:$D$100,SMALL(IF(ورقة1!$C$6:$C$100=$C$1,ROW($A$6:$A$100)-ROW($A$6)+1),ROWS($B$4:D12))),\"\")","v":""}]
[{"$f":"IF(B13=\"\",\"\",SUBTOTAL(3,$B$4:B13))","v":""},{"$f":"IFERROR(INDEX(ورقة1!$B$6:$B$100,SMALL(IF(ورقة1!$C$6:$C$100=$C$1,ROW($A$6:$A$100)-ROW($A$6)+1),ROWS($B$4:B13))),\"\")","v":""},{"$f":"IFERROR(INDEX(ورقة1!$C$6:$C$100,SMALL(IF(ورقة1!$C$6:$C$100=$C$1,ROW($A$6:$A$100)-ROW($A$6)+1),ROWS($B$4:C13))),\"\")","v":""},{"$f":"IFERROR(INDEX(ورقة1!$D$6:$D$100,SMALL(IF(ورقة1!$C$6:$C$100=$C$1,ROW($A$6:$A$100)-ROW($A$6)+1),ROWS($B$4:D13))),\"\")","v":""}]
[{"$f":"IF(B14=\"\",\"\",SUBTOTAL(3,$B$4:B14))","v":""},{"$f":"IFERROR(INDEX(ورقة1!$B$6:$B$100,SMALL(IF(ورقة1!$C$6:$C$100=$C$1,ROW($A$6:$A$100)-ROW($A$6)+1),ROWS($B$4:B14))),\"\")","v":""},{"$f":"IFERROR(INDEX(ورقة1!$C$6:$C$100,SMALL(IF(ورقة1!$C$6:$C$100=$C$1,ROW($A$6:$A$100)-ROW($A$6)+1),ROWS($B$4:C14))),\"\")","v":""},{"$f":"IFERROR(INDEX(ورقة1!$D$6:$D$100,SMALL(IF(ورقة1!$C$6:$C$100=$C$1,ROW($A$6:$A$100)-ROW($A$6)+1),ROWS($B$4:D14))),\"\")","v":""}]