{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["اعادة ترتيب عمود طبقاٌلعمود اخر","حذف كلمة من عمود مكررة"],"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":"اعادة ترتيب عمود طبقاٌلعمود اخر","index":0,"n_rows":170,"n_cols":10,"rows_kept":170,"cut":false,"hidden":false,"merged":[[1,9,19,15]]}
[1096049158,2351518788,{"$f":"IF($A1<>\"\",VLOOKUP(A1,$B$1:$B$170,1,0),\"\")","v":1096049158}]
[1111506232,2474931652,{"$f":"IF($A2<>\"\",VLOOKUP(A2,$B$1:$B$170,1,0),\"\")","v":1111506232},null,null,null,null,null,null,"احتاج اتعلم \nارتب العمود B يكون نفس ارقام العمود A\nبمعني دي ارقام هويات احتاج رقم الهوية اللى بالعمود B \nتكون مقابله لنفس الرقم بالعمود B"]
[2240079836,2457236251,2240079836]
[2259067714,2472176631,2259067714]
[2428269951,1096049158,2428269951]
[2395380211,1111506232,2395380211]
[2279479592,2240079836,2279479592]
[2325652614,2259067714,2325652614]
[2376557340,2428269951,2376557340]
[2401290610,2395380211,2401290610]
[2498226006,2279479592,2498226006]
[2265768644,2325652614,2265768644]
[2448609285,2376557340,2448609285]
[2351518788,2401290610,2351518788]
[2474931652,2498226006,2474931652]
[2457236251,2265768644,2457236251]
[2472176631,2448609285,2472176631]
[2313736007,2485449744,2313736007]
[2463454237,2487846830,2463454237]
[2245066416,2491031262,2245066416]
[1122403411,2491031320,1122403411]
[2288304856,2498040530,2288304856]
[2448608998,2357649736,2448608998]
[2474259633,2382103279,2474259633]
[2432403042,2441650708,2432403042]
[2462331816,2290193859,2462331816]
[2496216884,2443016890,2496216884]
[2490699614,2499347264,2490699614]
[2448609400,2432147177,2448609400]
[2485851931,2496915998,2485851931]
[2508983976,1126162989,2508983976]
[1106287467,1064907858,1106287467]
[2337262394,2345681007,2337262394]
[2354806800,2345251728,2354806800]
[2496488129,2472181730,2496488129]
[2403864065,2342181548,2403864065]
[2508984321,2320914027,2508984321]
[2509072720,2339266971,2509072720]
[1018088276,2340688403,1018088276]
[1087217293,2293563207,1087217293]
[2307004743,2280970373,2307004743]
[2429158203,2474364862,2429158203]
[2307443644,2432403190,2307443644]
[2491214355,2445033547,2491214355]
[2483957193,2457607410,2483957193]
[2446311363,2498051149,2446311363]
[2473395743,2303820225,2473395743]
[2496749850,2463454567,2496749850]
[2432146922,2437358738,2432146922]
[2267042725,2491228082,2267042725]
[2497438362,1008131011,2497438362]
[2499055388,1008131003,2499055388]
[2492542721,1165964501,2492542721]
[2460225234,1108468685,2460225234]
[1118080983,1007779570,1118080983]
[2455713194,1101010773,2455713194]
[2348006095,1127980728,2348006095]
[2432485023,1078641634,2432485023]
[2373986740,1114116724,2373986740]
[2467961062,1076474079,2467961062]
[2472399993,1005502289,2472399993]
[2509392334,1014237653,2509392334]
[2429603331,1116550300,2429603331]
[2479128841,1115731265,2479128841]
[2436462200,2041862398,2436462200]
[2432402960,2319758930,{"$f":"IF($A66<>\"\",VLOOKUP(A66,$B$1:$B$170,1,0),\"\")","v":2432402960}]
[2443396227,2271217370,2443396227]
[1109149961,2479303568,1109149961]
[1033977735,2230361780,1033977735]
[2319772394,2471395067,2319772394]
[2471639381,2471640009,2471639381]
[2480084942,2471394292,2480084942]
[2432601645,2471394573,2432601645]
[2432403125,2471396271,2432403125]
[2494781111,2471396370,2494781111]
[2474305006,2471486379,2474305006]
[2471566188,2479119949,2471566188]
[2411694439,2479119790,2411694439]
[2333314298,2495299212,2333314298]
[2485449744,2313736007,2485449744]
[2487846830,2463454237,2487846830]
[2491031262,2245066416,2491031262]
[2491031320,1122403411,2491031320]
[2498040530,2288304856,2498040530]
[2357649736,2448608998,2357649736]
[2382103279,2474259633,2382103279]
[2441650708,2432403042,2441650708]
[2290193859,2462331816,2290193859]
[2443016890,2496216884,2443016890]
[2499347264,2490699614,2499347264]
[2432147177,2448609400,2432147177]
[2496915998,2485851931,2496915998]
[1126162989,2508983976,1126162989]
[1064907858,1106287467,1064907858]
[2345681007,2337262394,2345681007]
[2345251728,2354806800,2345251728]
[2472181730,2496488129,2472181730]
[2342181548,2403864065,2342181548]
[2320914027,2508984321,2320914027]
[2339266971,2509072720,2339266971]
[2340688403,1018088276,2340688403]
[2293563207,1087217293,2293563207]
[2280970373,2307004743,2280970373]
[2474364862,2429158203,2474364862]
[2432403190,2307443644,2432403190]
[2445033547,2491214355,2445033547]
[2457607410,2483957193,2457607410]
[2498051149,2446311363,2498051149]
[2303820225,2473395743,2303820225]
[2463454567,2496749850,2463454567]
[2437358738,2432146922,2437358738]
[2491228082,2267042725,2491228082]
[1008131011,2497438362,1008131011]
[1008131003,2499055388,1008131003]
[1165964501,2492542721,1165964501]
[1108468685,2460225234,1108468685]
[1007779570,1118080983,1007779570]
[1101010773,2455713194,1101010773]
[1127980728,2348006095,1127980728]
[1078641634,2432485023,1078641634]
[1114116724,2373986740,1114116724]
[1076474079,2467961062,1076474079]
[1005502289,2472399993,1005502289]
[1014237653,2509392334,1014237653]
[1116550300,2429603331,1116550300]
[1115731265,2479128841,1115731265]
[2041862398,2436462200,2041862398]
[2319758930,2432402960,2319758930]
[2271217370,2443396227,2271217370]
[2479303568,1109149961,{"$f":"IF($A130<>\"\",VLOOKUP(A130,$B$1:$B$170,1,0),\"\")","v":2479303568}]
[2230361780,1033977735,2230361780]
[2471395067,2319772394,2471395067]
[2471640009,2471639381,2471640009]
[2471394292,2480084942,2471394292]
[2471394573,2432601645,2471394573]
[2471396271,2432403125,2471396271]
[2471396370,2494781111,2471396370]
[2471486379,2474305006,2471486379]
[2479119949,2471566188,2479119949]
[2479119790,2411694439,2479119790]
[2495299212,2333314298,2495299212]
[2492646233,2440674071,2492646233]
[2495139038,2313555035,2495139038]
[2229217761,2437731918,2229217761]
[2501401711,2443169632,2501401711]
[1092715257,2301127300,1092715257]
[2394121459,2509072548,2394121459]
[2381187448,2395380211,2381187448]
[2440674071,2495679371,2440674071]
[2313555035,2498100706,2313555035]
[2437731918,2301345399,2437731918]
[2443169632,2412266534,2443169632]
[2301127300,2387677608,2301127300]
[2509072548,2490378706,2509072548]
[2395380211,2496985868,2395380211]
[2495679371,2435669714,2495679371]
[2498100706,2450314782,2498100706]
[2301345399,2381145016,2301345399]
[2412266534,2480876453,2412266534]
[2387677608,2304641083,2387677608]
[2490378706,1130531492,2490378706]
[2496985868,2503781482,2496985868]
[2435669714,2492646233,2435669714]
[2450314782,2495139038,2450314782]
[2381145016,2229217761,2381145016]
[2480876453,2501401711,2480876453]
[2304641083,1092715257,2304641083]
[1073576264,2394121459,1073576264]
[1130531492,2381187448,1130531492]
[2503781482,1073576264,2503781482]

{"sheet":"حذف كلمة من عمود مكررة","index":1,"n_rows":172,"n_cols":3,"rows_kept":172,"cut":false,"hidden":false,"merged":[[1,2,19,8]]}
[" عبدالله لخزع ",2290193859]
[" MD MIA ",2472176631,"احتاج اتعلم \nكيف احذف كلمة ( الاسيم:) \nو ( كلمة ( رقم الهوية : ) من كل عمود\n وترك باقي الأرقام او الاسم\n( يعني حذف الكلمة المكررة وترك باقي بيانات الخليه )"]
[" ايمن النقيب ",2245066416]
[" MD UDDIN ",2472181730]
[" ابراهيم ال مستنير ",1076760774]
[" شفيق اليباري ",2307004743]
[" MD MD ",2471395067]
[" ريم الشريان ",1073576264]
[" مبارك لخسل ",2325652614]
[" MD HOSSAIN ",2471394292]
[" يحي الفرح ",2313736007]
[" MD MD ",2471640009]
[" MD HOSEN ",2471394573]
[" عبده باعلوي ",2303820225]
[" MD SUKKUR ",2471396271]
[" عماد عيون السود ",2229217761]
[" أصيل المشرقي ",2474364862]
[" عماد علي ",2265768644]
[" ارفيند باندي ",2474931652]
[" محمد وسيم ",2345251728]
[" SHOMON MIA ",2479128841]
[" مطهر سلمان ",2293563207]
[" سالم المسن ",2333314298]
[" عبدوه مقبل ",2267042725]
[" بسام العماد ",2509392334]
[" صادق البدوي ",2490699614]
[" محمد العيدروس ",2509072720]
[" طه الاسد ",2288304856]
[" حمزه الصلاحي ",2480084942]
[" نصر قايد الزهري ",2357649736]
[" MOHAMMAD HAQUE ",2485851931]
[" MD HOSSAN ",2496915998]
[" نار محمد ",2432147177]
[" حنان بكارى ",1130531492]
[" MOHAMMAD HOSSAIN ",2491214355]
[" مد ايلياس ",2432146922]
[" MOHAMMAD KAYUM ",2491031320]
[" MOHAMMAD HOSSAIN ",2429158203]
[" JAHANGIR ALAM ",2487846830]
[" SIFUL RAHMAN ",2436462200]
[" محمد الصباغ ",2492542721]
[" IQBAL HOSSAIN ",2435669714]
[" MD MIA ",2501401711]
[" SAGOR AHMMED ",2499055388]
[" عامر فرحان ",2494781111]
[" MD MIA ",2498226006]
[" عبداللطيف قاسم ",2496216884]
[" شوقي طاهر ",2441650708]
[" MONIR HOSSAIN ",2496985868]
[" عبدالله تعلب ",2432485023]
[" MASUD MIAH ",2495679371]
[" هيثم الجعفري ",2448609285]
[" راشد الشكريه ",1027679784]
[" حمزه العصفور ",2496488129]
[" محمد احمد الشجاع ",2448609400]
[" رمزي صالح ",2496749850]
[" حذيفه صالح ",2455713194]
[" وائل الوايلي ",2498051149]
[" عبدالحميد محمد ",2460225234]
[" طارق مقبل ",2508984321]
[" MUNNAT MONDAL ",2463454567]
[" MD ISLAM ",2467961062]
[" MIRKASHIM ALI ",2463454237]
[" عبدالرحمن السفياني ",1111506232]
[" محمود بغال ",2301345399]
[" حمزه الوجيه ",2457607410]
[" عمر الشهري ",1115731265]
[" EMDADUL ALI ",2471566188]
[" فاطمة الشهري ",1127980728]
[" MOHAMMAD MD ",2471396370]
[" ALAMIN SHOYAL ",2471486379]
[" عائشه القحطاني ",1101010773]
[" MOHAMMAD MIAH ",2471639381]
[" جميله القرني ",1078641634]
[" رجب فرغلى ",2480876453]
[" SULTAN MIAH ",2474259633]
[" محمد اليباري ",2474305006]
[" سميره القرني ",1114116724]
[" MONIN MOSTAFA ",2472399993]
[" شاكر المونسي ",2473395743]
[" ابراهيم شادى ",2411694439]
[" MOHAMMED RASEL ",2429603331]
[" MIJANUR SHAJAHAN ",2432403125]
[" MD KARIM ",2479119790]
[" MD ALI ",2479119949]
[" SUHEL MOHAMMAD ",2479303568]
[" رضوان الزهري ",2483957193]
[" أنفال الشيخ ",1092715257]
[" DAUDUL ISLAM ",2437358738]
[" مصطفى جمعه ",2503781482]
[" فاطمه المبرزي ",1126162989]
[" فله غزواني ",1018088276]
[" MOHAMMAD LITON ",2437731918]
[" طارق الزهراني ",1109149961]
[" محمد عبدالعاطى ",2304641083]
[" منير اسلام ",2443016890]
[" عبدالله السهيمي ",1096049158]
[" TUTUL MATUBBAR ",2440674071]
[" هدى الشهري ",1106287467]
[" MD MATUBBAR ",2443169632]
[" فاطمه الاسمري ",1033977735]
[" مود فارك ",2445033547]
[" ABDULLAH AL MAMUN ",2450314782]
[" سارا الشهري ",1005502289]
[" يحي حسن ",2446311363]
[" ATAUL KARIM ",2443396227]
[" حياة السفياني ",1165964501]
[" شموخ السفياني ",1108468685]
[" هشام النفيش ",2448608998]
[" سالم التليدي ",1087217293]
[" يحيى دحبيل ",2457236251]
[" شهد القرني ",1116550300]
[" عبدالرحمن المضرحي ",2462331816]
[" رمزي الصغيري ",2412266534]
[" فطيمه الرشيدي ",1064907858]
[" فاطمه القرني ",1014237653]
[" عوض الشهري ",1118080983]
[" فوزيه السفياني ",1008131011]
[" جمال دانيال ",2387677608]
[" ريم المنصوري ",1122403411]
[" هديل الضويحى ",1007779570]
[" راشد ابو عاصي ",2428269951]
[" تهاني الشهري ",1076474079]
[" RASEL HANIF FAKIR ",2432403190]
[" HASAN SHARIF ",2432403042]
[" HAFIJUR RAHAMAN ",2432402960]
[" نوره السفياني ",1008131003]
[" OVI ISLAM ",2432601645]
[" مصطفى السفياني ",2320914027]
[" عدنان عبدالملك ",2351518788]
[" عبده احمد ",2381187448]
[" عبده العجل ",2382103279]
[" عمر محمد ",2279479592]
[" محمود احمد الدبور ",2395380211]
[" محمد ادريس ",2394121459]
[" SHAJAHAN UDDIN ",2403864065]
[" منى الرشيدي ",1054385198]
[" سام العيدروس ",2240079836]
[" مختار الشجاع ",2307443644]
[" KHALELULLAH SARANDAZ ",2041862398]
[" MOHD RASHID ",2313555035]
[" ضاحى جعفر ",2259067714]
[" باسم العبدالله ",2319758930]
[" احمد الجبرتي ",2319772394]
[" ناجي شرخ ",2280970373]
[" طارق حسن ",2271217370]
[" احمد الاسد ",2342181548]
[" عبدالرحمن الجنيدي ",2340688403]
[" يوسف قائد ",2348006095]
[" محمد اليوسفي ",2337262394]
[" أحمد شريويت ",2301127300]
[" عمر الاسد ",2345681007]
[" يحي مشهور ",2354806800]
[" عبدالملك الشاطبي ",2485449744]
[" محمود سالم ",2490378706]
[" MD ARIF ",2492646233]
[" عمر ابراهيم ",2365088653]
[" MD MIA ",2491228082]
[" MOHAMMAD HOSSAIN ",2491031262]
[" كمال هاري ",2373986740]
[" MD TIPU SHEIKH ",2495299212]
[" نادر العواضي ",2376557340]
[" عبد المعز الخولى ",2495139038]
[" نبيل جارالله ",2381145016]
[" MD ALI ",2497438362]
[" وائل نور الدين ",2401290610]
[" علي عكي ",2339266971]
[" عبدالجبار صالح ",2498040530]
[" حمزه المضرحي ",2499347264]
[" ABDUL KHALIL ",2498100706]
[" يونس السباعي ",2509072548]
[" عادل الاهدل ",2508983976]