{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["ورقة1","salim"],"not_rendered":{"charts":0,"images":0,"macros":1,"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":9,"n_cols":18,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,14,0,17],[1,1,2,5],[3,2,3,4]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"البيانات "]
[null,"اريد هنا فرز تخصص الإدارة حسب كل اسم كما في البيانات"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"التخصص","الاعمال","التقنية","المالية","العلوم"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"احمد","سالم","شاكر","ليلى"]
[null,null,"الإدارة",null,null,null,null,null,null,null,null,null,null,null,"محمد","عبدالرجمن","ياسر","مريم"]
[null,1,"التقنية",{"$f":"IFERROR(INDEX($O$4:$R$7,COLUMNS($A$1:A1),MATCH($C6,$O$3:$R$3,0)),\"\")","v":"سالم"},{"$f":"IFERROR(INDEX($O$4:$R$7,COLUMNS($A$1:B1),MATCH($C6,$O$3:$R$3,0)),\"\")","v":"عبدالرجمن"},{"$f":"IFERROR(INDEX($O$4:$R$7,COLUMNS($A$1:C1),MATCH($C6,$O$3:$R$3,0)),\"\")","v":0},{"$f":"IFERROR(INDEX($O$4:$R$7,COLUMNS($A$1:D1),MATCH($C6,$O$3:$R$3,0)),\"\")","v":0},{"$f":"IFERROR(INDEX($O$4:$R$7,COLUMNS($A$1:E1),MATCH($C6,$O$3:$R$3,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($O$4:$R$7,COLUMNS($A$1:F1),MATCH($C6,$O$3:$R$3,0)),\"\")","v":""},null,null,null,null,null,"علي"]
[null,2,"الاعمال",{"$f":"IFERROR(INDEX($O$4:$R$7,COLUMNS($A$1:A2),MATCH($C7,$O$3:$R$3,0)),\"\")","v":"احمد"},{"$f":"IFERROR(INDEX($O$4:$R$7,COLUMNS($A$1:B2),MATCH($C7,$O$3:$R$3,0)),\"\")","v":"محمد"},{"$f":"IFERROR(INDEX($O$4:$R$7,COLUMNS($A$1:C2),MATCH($C7,$O$3:$R$3,0)),\"\")","v":"علي"},{"$f":"IFERROR(INDEX($O$4:$R$7,COLUMNS($A$1:D2),MATCH($C7,$O$3:$R$3,0)),\"\")","v":"خالد"},{"$f":"IFERROR(INDEX($O$4:$R$7,COLUMNS($A$1:E2),MATCH($C7,$O$3:$R$3,0)),\"\")","v":""},null,null,null,null,null,null,"خالد"]
[null,3,"المالية",{"$f":"IFERROR(INDEX($O$4:$R$7,COLUMNS($A$1:A3),MATCH($C8,$O$3:$R$3,0)),\"\")","v":"شاكر"},{"$f":"IFERROR(INDEX($O$4:$R$7,COLUMNS($A$1:B3),MATCH($C8,$O$3:$R$3,0)),\"\")","v":"ياسر"},{"$f":"IFERROR(INDEX($O$4:$R$7,COLUMNS($A$1:C3),MATCH($C8,$O$3:$R$3,0)),\"\")","v":0},{"$f":"IFERROR(INDEX($O$4:$R$7,COLUMNS($A$1:D3),MATCH($C8,$O$3:$R$3,0)),\"\")","v":0}]
[null,4,"العلوم",{"$f":"IFERROR(INDEX($O$4:$R$7,COLUMNS($A$1:A4),MATCH($C9,$O$3:$R$3,0)),\"\")","v":"ليلى"},{"$f":"IFERROR(INDEX($O$4:$R$7,COLUMNS($A$1:B4),MATCH($C9,$O$3:$R$3,0)),\"\")","v":"مريم"},{"$f":"IFERROR(INDEX($O$4:$R$7,COLUMNS($A$1:C4),MATCH($C9,$O$3:$R$3,0)),\"\")","v":0},{"$f":"IFERROR(INDEX($O$4:$R$7,COLUMNS($A$1:D4),MATCH($C9,$O$3:$R$3,0)),\"\")","v":0}]

{"sheet":"salim","index":1,"n_rows":21,"n_cols":18,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,14,0,17],[1,1,2,5],[3,2,3,4],[20,3,20,16],[17,6,17,14]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"البيانات "]
[null,"اريد هنا فرز تخصص الإدارة حسب كل اسم كما في البيانات"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"التخصص","الاعمال","التقنية","المالية","العلوم"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"احمد","سالم","شاكر","ليلى"]
[null,null,"الإدارة",null,null,null,null,null,null,null,null,null,null,null,"محمد","عبدالرجمن","ياسر","مريم"]
[null,1,"التقنية","سالم",null,null,null,null,{"$f":"IFERROR(INDEX($O$4:$R$7,COLUMNS($A$1:F1),MATCH($C6,$O$3:$R$3,0)),\"\")","v":""},null,null,null,null,null,"علي"]
[null,2,"المالية","شاكر",null,null,null,null,null,null,null,null,null,null,"خالد"]
[null,3,"العلوم","ليلى"]
[null,4,"العلوم","ليلى"]
[]
[null,null,"الإدارة"]
[null,null,"التقنية","عبدالرجمن"]
[null,null,"الاعمال","محمد"]
[null,null,"المالية","ياسر"]
[null,null,"الاعمال","خالد"]
[null,null,"العلوم","مريم"]
[null,null,"التقنية","سالم"]
[null,null,null,null,null,null,"الداله المستخدمه يتم وضعها في Data Validation"]
[]
[]
[null,null,null,"IF(C12=$O$3;$O$4:$O$7;IF(C12=$P$3;$P$4:$P$7;IF(C12=$Q$3;$Q$4:$Q$7;IF(C12=$R$3;$R$4:$R$7;\"\"))))"]