{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Salim","ورقة1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"Salim","index":0,"n_rows":33,"n_cols":13,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["الرئيسية",null,null,null,"الفرعي","اسم الام للفرعي","ارقام الفرعي",null,"الفرعي","اسم الام للفرعي","ارقام الفرعي"]
["A1",null,null,null,"A23","a1",12345,null,{"$f":"IF(ROWS($A$1:A1)>SUM(IF(COUNTIF($A$2:$A$14,$E$2:$E$14)+COUNTIF($E$2:$E$14,$A$2:$A$14)=2,1,0)),\"\",INDEX(E$2:E$14,SMALL(IF(COUNTIF($A$2:$A$14,$E$2:$E$14)+COUNTIF($E$2:$E$14,$A$2:$A$14)=2,ROW($E$2:$E$14)-ROW($E$2)+1),ROWS($A$1:A1))))","v":"A7"},{"$f":"IF(ROWS($A$1:B1)>SUM(IF(COUNTIF($A$2:$A$14,$E$2:$E$14)+COUNTIF($E$2:$E$14,$A$2:$A$14)=2,1,0)),\"\",INDEX(F$2:F$14,SMALL(IF(COUNTIF($A$2:$A$14,$E$2:$E$14)+COUNTIF($E$2:$E$14,$A$2:$A$14)=2,ROW($E$2:$E$14)-ROW($E$2)+1),ROWS($A$1:B1))))","v":"a7"},{"$f":"IF(ROWS($A$1:C1)>SUM(IF(COUNTIF($A$2:$A$14,$E$2:$E$14)+COUNTIF($E$2:$E$14,$A$2:$A$14)=2,1,0)),\"\",INDEX(G$2:G$14,SMALL(IF(COUNTIF($A$2:$A$14,$E$2:$E$14)+COUNTIF($E$2:$E$14,$A$2:$A$14)=2,ROW($E$2:$E$14)-ROW($E$2)+1),ROWS($A$1:C1))))","v":123456}]
["A10",null,null,null,"A19","a2",567900,null,{"$f":"IF(ROWS($A$1:A2)>SUM(IF(COUNTIF($A$2:$A$14,$E$2:$E$14)+COUNTIF($E$2:$E$14,$A$2:$A$14)=2,1,0)),\"\",INDEX(E$2:E$14,SMALL(IF(COUNTIF($A$2:$A$14,$E$2:$E$14)+COUNTIF($E$2:$E$14,$A$2:$A$14)=2,ROW($E$2:$E$14)-ROW($E$2)+1),ROWS($A$1:A2))))","v":"A2"},{"$f":"IF(ROWS($A$1:B2)>SUM(IF(COUNTIF($A$2:$A$14,$E$2:$E$14)+COUNTIF($E$2:$E$14,$A$2:$A$14)=2,1,0)),\"\",INDEX(F$2:F$14,SMALL(IF(COUNTIF($A$2:$A$14,$E$2:$E$14)+COUNTIF($E$2:$E$14,$A$2:$A$14)=2,ROW($E$2:$E$14)-ROW($E$2)+1),ROWS($A$1:B2))))","v":"a10"},{"$f":"IF(ROWS($A$1:C2)>SUM(IF(COUNTIF($A$2:$A$14,$E$2:$E$14)+COUNTIF($E$2:$E$14,$A$2:$A$14)=2,1,0)),\"\",INDEX(G$2:G$14,SMALL(IF(COUNTIF($A$2:$A$14,$E$2:$E$14)+COUNTIF($E$2:$E$14,$A$2:$A$14)=2,ROW($E$2:$E$14)-ROW($E$2)+1),ROWS($A$1:C2))))","v":790122}]
["A11",null,null,null,"A31","a3",901233,null,{"$f":"IF(ROWS($A$1:A3)>SUM(IF(COUNTIF($A$2:$A$14,$E$2:$E$14)+COUNTIF($E$2:$E$14,$A$2:$A$14)=2,1,0)),\"\",INDEX(E$2:E$14,SMALL(IF(COUNTIF($A$2:$A$14,$E$2:$E$14)+COUNTIF($E$2:$E$14,$A$2:$A$14)=2,ROW($E$2:$E$14)-ROW($E$2)+1),ROWS($A$1:A3))))","v":""},{"$f":"IF(ROWS($A$1:B3)>SUM(IF(COUNTIF($A$2:$A$14,$E$2:$E$14)+COUNTIF($E$2:$E$14,$A$2:$A$14)=2,1,0)),\"\",INDEX(F$2:F$14,SMALL(IF(COUNTIF($A$2:$A$14,$E$2:$E$14)+COUNTIF($E$2:$E$14,$A$2:$A$14)=2,ROW($E$2:$E$14)-ROW($E$2)+1),ROWS($A$1:B3))))","v":""},{"$f":"IF(ROWS($A$1:C3)>SUM(IF(COUNTIF($A$2:$A$14,$E$2:$E$14)+COUNTIF($E$2:$E$14,$A$2:$A$14)=2,1,0)),\"\",INDEX(G$2:G$14,SMALL(IF(COUNTIF($A$2:$A$14,$E$2:$E$14)+COUNTIF($E$2:$E$14,$A$2:$A$14)=2,ROW($E$2:$E$14)-ROW($E$2)+1),ROWS($A$1:C3))))","v":""}]
["A13",null,null,null,"A33","a4",345678,null,{"$f":"IF(ROWS($A$1:A4)>SUM(IF(COUNTIF($A$2:$A$14,$E$2:$E$14)+COUNTIF($E$2:$E$14,$A$2:$A$14)=2,1,0)),\"\",INDEX(E$2:E$14,SMALL(IF(COUNTIF($A$2:$A$14,$E$2:$E$14)+COUNTIF($E$2:$E$14,$A$2:$A$14)=2,ROW($E$2:$E$14)-ROW($E$2)+1),ROWS($A$1:A4))))","v":""},{"$f":"IF(ROWS($A$1:B4)>SUM(IF(COUNTIF($A$2:$A$14,$E$2:$E$14)+COUNTIF($E$2:$E$14,$A$2:$A$14)=2,1,0)),\"\",INDEX(F$2:F$14,SMALL(IF(COUNTIF($A$2:$A$14,$E$2:$E$14)+COUNTIF($E$2:$E$14,$A$2:$A$14)=2,ROW($E$2:$E$14)-ROW($E$2)+1),ROWS($A$1:B4))))","v":""},{"$f":"IF(ROWS($A$1:C4)>SUM(IF(COUNTIF($A$2:$A$14,$E$2:$E$14)+COUNTIF($E$2:$E$14,$A$2:$A$14)=2,1,0)),\"\",INDEX(G$2:G$14,SMALL(IF(COUNTIF($A$2:$A$14,$E$2:$E$14)+COUNTIF($E$2:$E$14,$A$2:$A$14)=2,ROW($E$2:$E$14)-ROW($E$2)+1),ROWS($A$1:C4))))","v":""}]
["A15",null,null,null,"A21","a5",679011,null,{"$f":"IF(ROWS($A$1:A5)>SUM(IF(COUNTIF($A$2:$A$14,$E$2:$E$14)+COUNTIF($E$2:$E$14,$A$2:$A$14)=2,1,0)),\"\",INDEX(E$2:E$14,SMALL(IF(COUNTIF($A$2:$A$14,$E$2:$E$14)+COUNTIF($E$2:$E$14,$A$2:$A$14)=2,ROW($E$2:$E$14)-ROW($E$2)+1),ROWS($A$1:A5))))","v":""},{"$f":"IF(ROWS($A$1:B5)>SUM(IF(COUNTIF($A$2:$A$14,$E$2:$E$14)+COUNTIF($E$2:$E$14,$A$2:$A$14)=2,1,0)),\"\",INDEX(F$2:F$14,SMALL(IF(COUNTIF($A$2:$A$14,$E$2:$E$14)+COUNTIF($E$2:$E$14,$A$2:$A$14)=2,ROW($E$2:$E$14)-ROW($E$2)+1),ROWS($A$1:B5))))","v":""},{"$f":"IF(ROWS($A$1:C5)>SUM(IF(COUNTIF($A$2:$A$14,$E$2:$E$14)+COUNTIF($E$2:$E$14,$A$2:$A$14)=2,1,0)),\"\",INDEX(G$2:G$14,SMALL(IF(COUNTIF($A$2:$A$14,$E$2:$E$14)+COUNTIF($E$2:$E$14,$A$2:$A$14)=2,ROW($E$2:$E$14)-ROW($E$2)+1),ROWS($A$1:C5))))","v":""}]
["A18",null,null,null,"A32","a6",456789,null,{"$f":"IF(ROWS($A$1:A6)>SUM(IF(COUNTIF($A$2:$A$14,$E$2:$E$14)+COUNTIF($E$2:$E$14,$A$2:$A$14)=2,1,0)),\"\",INDEX(E$2:E$14,SMALL(IF(COUNTIF($A$2:$A$14,$E$2:$E$14)+COUNTIF($E$2:$E$14,$A$2:$A$14)=2,ROW($E$2:$E$14)-ROW($E$2)+1),ROWS($A$1:A6))))","v":""},{"$f":"IF(ROWS($A$1:B6)>SUM(IF(COUNTIF($A$2:$A$14,$E$2:$E$14)+COUNTIF($E$2:$E$14,$A$2:$A$14)=2,1,0)),\"\",INDEX(F$2:F$14,SMALL(IF(COUNTIF($A$2:$A$14,$E$2:$E$14)+COUNTIF($E$2:$E$14,$A$2:$A$14)=2,ROW($E$2:$E$14)-ROW($E$2)+1),ROWS($A$1:B6))))","v":""},{"$f":"IF(ROWS($A$1:C6)>SUM(IF(COUNTIF($A$2:$A$14,$E$2:$E$14)+COUNTIF($E$2:$E$14,$A$2:$A$14)=2,1,0)),\"\",INDEX(G$2:G$14,SMALL(IF(COUNTIF($A$2:$A$14,$E$2:$E$14)+COUNTIF($E$2:$E$14,$A$2:$A$14)=2,ROW($E$2:$E$14)-ROW($E$2)+1),ROWS($A$1:C6))))","v":""}]
["A19",null,null,null,"A7","a7",123456,null,{"$f":"IF(ROWS($A$1:A7)>SUM(IF(COUNTIF($A$2:$A$14,$E$2:$E$14)+COUNTIF($E$2:$E$14,$A$2:$A$14)=2,1,0)),\"\",INDEX(E$2:E$14,SMALL(IF(COUNTIF($A$2:$A$14,$E$2:$E$14)+COUNTIF($E$2:$E$14,$A$2:$A$14)=2,ROW($E$2:$E$14)-ROW($E$2)+1),ROWS($A$1:A7))))","v":""},{"$f":"IF(ROWS($A$1:B7)>SUM(IF(COUNTIF($A$2:$A$14,$E$2:$E$14)+COUNTIF($E$2:$E$14,$A$2:$A$14)=2,1,0)),\"\",INDEX(F$2:F$14,SMALL(IF(COUNTIF($A$2:$A$14,$E$2:$E$14)+COUNTIF($E$2:$E$14,$A$2:$A$14)=2,ROW($E$2:$E$14)-ROW($E$2)+1),ROWS($A$1:B7))))","v":""},{"$f":"IF(ROWS($A$1:C7)>SUM(IF(COUNTIF($A$2:$A$14,$E$2:$E$14)+COUNTIF($E$2:$E$14,$A$2:$A$14)=2,1,0)),\"\",INDEX(G$2:G$14,SMALL(IF(COUNTIF($A$2:$A$14,$E$2:$E$14)+COUNTIF($E$2:$E$14,$A$2:$A$14)=2,ROW($E$2:$E$14)-ROW($E$2)+1),ROWS($A$1:C7))))","v":""}]
["A2",null,null,null,"A28","a8",1345677,null,{"$f":"IF(ROWS($A$1:A8)>SUM(IF(COUNTIF($A$2:$A$14,$E$2:$E$14)+COUNTIF($E$2:$E$14,$A$2:$A$14)=2,1,0)),\"\",INDEX(E$2:E$14,SMALL(IF(COUNTIF($A$2:$A$14,$E$2:$E$14)+COUNTIF($E$2:$E$14,$A$2:$A$14)=2,ROW($E$2:$E$14)-ROW($E$2)+1),ROWS($A$1:A8))))","v":""},{"$f":"IF(ROWS($A$1:B8)>SUM(IF(COUNTIF($A$2:$A$14,$E$2:$E$14)+COUNTIF($E$2:$E$14,$A$2:$A$14)=2,1,0)),\"\",INDEX(F$2:F$14,SMALL(IF(COUNTIF($A$2:$A$14,$E$2:$E$14)+COUNTIF($E$2:$E$14,$A$2:$A$14)=2,ROW($E$2:$E$14)-ROW($E$2)+1),ROWS($A$1:B8))))","v":""},{"$f":"IF(ROWS($A$1:C8)>SUM(IF(COUNTIF($A$2:$A$14,$E$2:$E$14)+COUNTIF($E$2:$E$14,$A$2:$A$14)=2,1,0)),\"\",INDEX(G$2:G$14,SMALL(IF(COUNTIF($A$2:$A$14,$E$2:$E$14)+COUNTIF($E$2:$E$14,$A$2:$A$14)=2,ROW($E$2:$E$14)-ROW($E$2)+1),ROWS($A$1:C8))))","v":""}]
["A2",null,null,null,"A22","a9",234567,null,{"$f":"IF(ROWS($A$1:A9)>SUM(IF(COUNTIF($A$2:$A$14,$E$2:$E$14)+COUNTIF($E$2:$E$14,$A$2:$A$14)=2,1,0)),\"\",INDEX(E$2:E$14,SMALL(IF(COUNTIF($A$2:$A$14,$E$2:$E$14)+COUNTIF($E$2:$E$14,$A$2:$A$14)=2,ROW($E$2:$E$14)-ROW($E$2)+1),ROWS($A$1:A9))))","v":""},{"$f":"IF(ROWS($A$1:B9)>SUM(IF(COUNTIF($A$2:$A$14,$E$2:$E$14)+COUNTIF($E$2:$E$14,$A$2:$A$14)=2,1,0)),\"\",INDEX(F$2:F$14,SMALL(IF(COUNTIF($A$2:$A$14,$E$2:$E$14)+COUNTIF($E$2:$E$14,$A$2:$A$14)=2,ROW($E$2:$E$14)-ROW($E$2)+1),ROWS($A$1:B9))))","v":""},{"$f":"IF(ROWS($A$1:C9)>SUM(IF(COUNTIF($A$2:$A$14,$E$2:$E$14)+COUNTIF($E$2:$E$14,$A$2:$A$14)=2,1,0)),\"\",INDEX(G$2:G$14,SMALL(IF(COUNTIF($A$2:$A$14,$E$2:$E$14)+COUNTIF($E$2:$E$14,$A$2:$A$14)=2,ROW($E$2:$E$14)-ROW($E$2)+1),ROWS($A$1:C9))))","v":""}]
["A20",null,null,null,"A2","a10",790122,null,{"$f":"IF(ROWS($A$1:A10)>SUM(IF(COUNTIF($A$2:$A$14,$E$2:$E$14)+COUNTIF($E$2:$E$14,$A$2:$A$14)=2,1,0)),\"\",INDEX(E$2:E$14,SMALL(IF(COUNTIF($A$2:$A$14,$E$2:$E$14)+COUNTIF($E$2:$E$14,$A$2:$A$14)=2,ROW($E$2:$E$14)-ROW($E$2)+1),ROWS($A$1:A10))))","v":""},{"$f":"IF(ROWS($A$1:B10)>SUM(IF(COUNTIF($A$2:$A$14,$E$2:$E$14)+COUNTIF($E$2:$E$14,$A$2:$A$14)=2,1,0)),\"\",INDEX(F$2:F$14,SMALL(IF(COUNTIF($A$2:$A$14,$E$2:$E$14)+COUNTIF($E$2:$E$14,$A$2:$A$14)=2,ROW($E$2:$E$14)-ROW($E$2)+1),ROWS($A$1:B10))))","v":""},{"$f":"IF(ROWS($A$1:C10)>SUM(IF(COUNTIF($A$2:$A$14,$E$2:$E$14)+COUNTIF($E$2:$E$14,$A$2:$A$14)=2,1,0)),\"\",INDEX(G$2:G$14,SMALL(IF(COUNTIF($A$2:$A$14,$E$2:$E$14)+COUNTIF($E$2:$E$14,$A$2:$A$14)=2,ROW($E$2:$E$14)-ROW($E$2)+1),ROWS($A$1:C10))))","v":""}]
["A5",null,null,null,"A32","a11",1123455,null,{"$f":"IF(ROWS($A$1:A11)>SUM(IF(COUNTIF($A$2:$A$14,$E$2:$E$14)+COUNTIF($E$2:$E$14,$A$2:$A$14)=2,1,0)),\"\",INDEX(E$2:E$14,SMALL(IF(COUNTIF($A$2:$A$14,$E$2:$E$14)+COUNTIF($E$2:$E$14,$A$2:$A$14)=2,ROW($E$2:$E$14)-ROW($E$2)+1),ROWS($A$1:A11))))","v":""},{"$f":"IF(ROWS($A$1:B11)>SUM(IF(COUNTIF($A$2:$A$14,$E$2:$E$14)+COUNTIF($E$2:$E$14,$A$2:$A$14)=2,1,0)),\"\",INDEX(F$2:F$14,SMALL(IF(COUNTIF($A$2:$A$14,$E$2:$E$14)+COUNTIF($E$2:$E$14,$A$2:$A$14)=2,ROW($E$2:$E$14)-ROW($E$2)+1),ROWS($A$1:B11))))","v":""},{"$f":"IF(ROWS($A$1:C11)>SUM(IF(COUNTIF($A$2:$A$14,$E$2:$E$14)+COUNTIF($E$2:$E$14,$A$2:$A$14)=2,1,0)),\"\",INDEX(G$2:G$14,SMALL(IF(COUNTIF($A$2:$A$14,$E$2:$E$14)+COUNTIF($E$2:$E$14,$A$2:$A$14)=2,ROW($E$2:$E$14)-ROW($E$2)+1),ROWS($A$1:C11))))","v":""}]
["A6",null,null,null,"A35","a12",1234566,null,{"$f":"IF(ROWS($A$1:A12)>SUM(IF(COUNTIF($A$2:$A$14,$E$2:$E$14)+COUNTIF($E$2:$E$14,$A$2:$A$14)=2,1,0)),\"\",INDEX(E$2:E$14,SMALL(IF(COUNTIF($A$2:$A$14,$E$2:$E$14)+COUNTIF($E$2:$E$14,$A$2:$A$14)=2,ROW($E$2:$E$14)-ROW($E$2)+1),ROWS($A$1:A12))))","v":""},{"$f":"IF(ROWS($A$1:B12)>SUM(IF(COUNTIF($A$2:$A$14,$E$2:$E$14)+COUNTIF($E$2:$E$14,$A$2:$A$14)=2,1,0)),\"\",INDEX(F$2:F$14,SMALL(IF(COUNTIF($A$2:$A$14,$E$2:$E$14)+COUNTIF($E$2:$E$14,$A$2:$A$14)=2,ROW($E$2:$E$14)-ROW($E$2)+1),ROWS($A$1:B12))))","v":""},{"$f":"IF(ROWS($A$1:C12)>SUM(IF(COUNTIF($A$2:$A$14,$E$2:$E$14)+COUNTIF($E$2:$E$14,$A$2:$A$14)=2,1,0)),\"\",INDEX(G$2:G$14,SMALL(IF(COUNTIF($A$2:$A$14,$E$2:$E$14)+COUNTIF($E$2:$E$14,$A$2:$A$14)=2,ROW($E$2:$E$14)-ROW($E$2)+1),ROWS($A$1:C12))))","v":""}]
["A7",null,null,null,"A27","a13",1012344,"`",{"$f":"IF(ROWS($A$1:A13)>SUM(IF(COUNTIF($A$2:$A$14,$E$2:$E$14)+COUNTIF($E$2:$E$14,$A$2:$A$14)=2,1,0)),\"\",INDEX(E$2:E$14,SMALL(IF(COUNTIF($A$2:$A$14,$E$2:$E$14)+COUNTIF($E$2:$E$14,$A$2:$A$14)=2,ROW($E$2:$E$14)-ROW($E$2)+1),ROWS($A$1:A13))))","v":""},{"$f":"IF(ROWS($A$1:B13)>SUM(IF(COUNTIF($A$2:$A$14,$E$2:$E$14)+COUNTIF($E$2:$E$14,$A$2:$A$14)=2,1,0)),\"\",INDEX(F$2:F$14,SMALL(IF(COUNTIF($A$2:$A$14,$E$2:$E$14)+COUNTIF($E$2:$E$14,$A$2:$A$14)=2,ROW($E$2:$E$14)-ROW($E$2)+1),ROWS($A$1:B13))))","v":""},{"$f":"IF(ROWS($A$1:C13)>SUM(IF(COUNTIF($A$2:$A$14,$E$2:$E$14)+COUNTIF($E$2:$E$14,$A$2:$A$14)=2,1,0)),\"\",INDEX(G$2:G$14,SMALL(IF(COUNTIF($A$2:$A$14,$E$2:$E$14)+COUNTIF($E$2:$E$14,$A$2:$A$14)=2,ROW($E$2:$E$14)-ROW($E$2)+1),ROWS($A$1:C13))))","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"يوجد ثلاثة أسماء متشابه باللون الأصفر عند بالقائمة الرئيسية ونفسها بالقائمة الفرعيية عند عمل تصفيه حسب الاحرف الابجدية "]
[null,null,null,null,null,null,null,null,null,null,null,null,"تتغير القائمة الرئيسية وبالتالي القائمة تتغير أيضا انا اريد ثبات القائمة الفرعية بعد التصفيه نفس تصفية القائمة الأولى بالضبط "]

{"sheet":"ورقة1","index":1,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["الفرعي","اسم الام للفرعي","ارقام الفرعي"]
["احمد عبدحسين سلمان","ابتسام احمد لطيف",123456]
["ازهار ستار صالح جاسم","عادلية حسين",901233]
["بشرى طاهر علوان","فطيم  علي  خضير",1234566]
["جوان طارق حسين الجميلي","لمياء علي صالح",1345677]
["سرى خليل اسماعيل","عمشه احمد جاسم",1012344]
["سلوى سعدون الياس","سميه نجم جاسم",12345]
["صفا موفق مزهر فهمي","هاجر علي",234567]
["فضاء علي رضا مصطفى","ليلي ناصر كاكي",790122]
["كفاح كاظم حميد التميمي","ابتسام سلمان حميد",567900]
["مثنى ياسين ردام الخيلاني","ليلى احمد موسى",679011]
["نبراس عبدالكريم محمود احمد","ابتسام احمد لطيف",456789]
["نداء صالح مهدي جواد","وطفه غلام جعفر",345678]
["وهران محمد حيدر محمود","حسنيه علي جاسم",1123455]