{"text_format":"1","workbook":"xlsx","n_sheets":1,"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":23,"n_cols":14,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,12,1,13],[2,9,2,10],[2,12,2,13],[0,9,1,10],[4,4,14,7]]}
[null,"الاسم","الجنسية",null,null,null,null,null,null,"الجدول المطلوب التعديل علية",null,null,"النتيجة المطلوبه"]
[null,"فلان 01","سعودي"]
[null,"فلان 02",null,null,null,null,null,null,null,"جدول 01",null,null,"جدول 02"]
[null,"فلان 03",null,null,null,null,null,null,null,"الاسم","الجنسية",null,"الاسم","الجنسية"]
[null,"فلان 04",null,null,"الاخوه الأعزاء الجدول 01 فيه معادله VLOOKUP  \n\nالمشكلة اذا اردت عد الخلايا التي تحتوي على الجنسية\n يقوم بعدها مع المعادله ارجو حل هذه المشكلة مع تلوين الخلايا التي تحتوي على أي جنسية كما في الجدول 02\n\nولكم وافر الامتنان",null,null,null,null,"فلان 10",{"$f":"IFERROR(VLOOKUP(J5,B2:C20,2,0),\"\")","v":"سعودي"},null,"فلان 10","سعودي"]
[null,"فلان 05","سوري",null,null,null,null,null,null,"فلان 11",{"$f":"IFERROR(VLOOKUP(J6,B3:C21,2,0),\"\")","v":0},null,"فلان 11"]
[null,"فلان 06",null,null,null,null,null,null,null,"فلان 12",0,null,"فلان 12"]
[null,"فلان 07",null,null,null,null,null,null,null,"فلان 13",0,null,"فلان 13"]
[null,"فلان 08","فلسطيني",null,null,null,null,null,null,"فلان 14","مصري",null,"فلان 14","مصري"]
[null,"فلان 09",null,null,null,null,null,null,null,"فلان 15",0,null,"فلان 15"]
[null,"فلان 10","سعودي",null,null,null,null,null,null,"فلان 16",0,null,"فلان 16"]
[null,"فلان 11",null,null,null,null,null,null,null,"فلان 17","اردني",null,"فلان 17","اردني"]
[null,"فلان 12",null,null,null,null,null,null,null,"فلان 18",0,null,"فلان 18"]
[null,"فلان 13",null,null,null,null,null,null,null,"فلان 19",0,null,"فلان 19"]
[null,"فلان 14","مصري",null,null,null,null,null,null,"فلان 20","",null,"فلان 20"]
[null,"فلان 15",null,null,null,null,null,null,null,"فلان 21","",null,"فلان 21"]
[null,"فلان 16",null,null,null,null,null,null,null,"فلان 22","",null,"فلان 22"]
[null,"فلان 17","اردني",null,null,null,null,null,null,"فلان 23","",null,"فلان 23"]
[null,"فلان 18",null,null,null,null,null,null,null,"فلان 24","",null,"فلان 24"]
[null,"فلان 19",null,null,null,null,null,null,null,"فلان 25","",null,"فلان 25"]
[null,null,null,null,null,null,null,null,null,"فلان 26","",null,"فلان 26"]
[null,"المجموع",{"$f":"COUNTA(C2:C20)","v":6}]
[null,null,null,null,null,null,null,null,null,"المجموع",{"$f":"COUNTA(K5:K21)","v":17},null,"المجموع",{"$f":"COUNTA(N5:N21)","v":3}]