{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["ورقة1","Sheet1"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"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":5,"n_cols":1,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["تعديل على كود البحث "]
[]
["https://www.officena.net/ib/topic/114262-تعديل-على-كود-البحث/"]
[]
["ارجو من حضراتكم التعديل على كود البحث بحيث يبحث في 3 اعمده كما هوه موضح "]

{"sheet":"Sheet1","index":1,"n_rows":106,"n_cols":8,"rows_kept":106,"cut":false,"hidden":false,"merged":[[1,3,1,6],[1,7,4,7],[1,2,4,2]]}
[]
[null,null,"الترقيم التلقائى  المستخدم بدالة Row","البحث بأى حرف من الاسم مع الترقيم التلقائى",null,null,null,"اضغط كليك يمين للفأرة على اسم الشيت ثم عرض التعليمات البرمجية لظهور الكود المستخدم فى الفلترة"]
[]
[]
[null,null,null,"الرقم","الاســــــــــــــــــــــــــــــــــــــــــم","العنوان","الموبايل"]
[null,null,null,{"$f":"IF(E6<>\"\",SUBTOTAL(103,$E$6:E6),\"\")","v":1},"عمر جاد ابونصار","سوهاج","0123446588"]
[null,null,null,{"$f":"IF(E7<>\"\",SUBTOTAL(103,$E$6:E7),\"\")","v":2},"كريم عزت","سوهاج","0251314558"]
[null,null,null,{"$f":"IF(E8<>\"\",SUBTOTAL(103,$E$6:E8),\"\")","v":3},"ياسر محمد","سوهاج","0231121686"]
[null,null,null,{"$f":"IF(E9<>\"\",SUBTOTAL(103,$E$6:E9),\"\")","v":4},"ياسين على","سوهاج","0554960554"]
[null,null,null,{"$f":"IF(E10<>\"\",SUBTOTAL(103,$E$6:E10),\"\")","v":5},"ياسر خليل","سوهاج","0125787888"]
[null,null,null,{"$f":"IF(E11<>\"\",SUBTOTAL(103,$E$6:E11),\"\")","v":6},"ياسر العربى","سوهاج","01122558947"]
[null,null,null,{"$f":"IF(E12<>\"\",SUBTOTAL(103,$E$6:E12),\"\")","v":7},"عمر جاد ابونصار","سوهاج","0123446588"]
[null,null,null,{"$f":"IF(E13<>\"\",SUBTOTAL(103,$E$6:E13),\"\")","v":8},"كريم عزت","مصر","0251314558"]
[null,null,null,{"$f":"IF(E14<>\"\",SUBTOTAL(103,$E$6:E14),\"\")","v":9},"ياسر محمد","القاهرة","0231121686"]
[null,null,null,{"$f":"IF(E15<>\"\",SUBTOTAL(103,$E$6:E15),\"\")","v":10},"ياسين على","اسيوط","0554960554"]
[null,null,null,{"$f":"IF(E16<>\"\",SUBTOTAL(103,$E$6:E16),\"\")","v":11},"ياسر خليل","مصر","0125787888"]
[null,null,null,{"$f":"IF(E17<>\"\",SUBTOTAL(103,$E$6:E17),\"\")","v":12},"ياسر العربى","مصر","01122558947"]
[null,null,null,{"$f":"IF(E18<>\"\",SUBTOTAL(103,$E$6:E18),\"\")","v":13},"عمر جاد ابونصار","سوهاج","0123446588"]
[null,null,null,{"$f":"IF(E19<>\"\",SUBTOTAL(103,$E$6:E19),\"\")","v":14},"كريم عزت","مصر","0251314558"]
[null,null,null,{"$f":"IF(E20<>\"\",SUBTOTAL(103,$E$6:E20),\"\")","v":15},"ياسر محمد","القاهرة","0231121686"]
[null,null,null,{"$f":"IF(E21<>\"\",SUBTOTAL(103,$E$6:E21),\"\")","v":16},"عمر جاد ابونصار","سوهاج","0123446588"]
[null,null,null,{"$f":"IF(E22<>\"\",SUBTOTAL(103,$E$6:E22),\"\")","v":17},"كريم عزت","مصر","0251314558"]
[null,null,null,{"$f":"IF(E23<>\"\",SUBTOTAL(103,$E$6:E23),\"\")","v":18},"ياسر محمد","القاهرة","0231121686"]
[null,null,null,{"$f":"IF(E24<>\"\",SUBTOTAL(103,$E$6:E24),\"\")","v":19},"ياسين على","اسيوط","0554960554"]
[null,null,null,{"$f":"IF(E25<>\"\",SUBTOTAL(103,$E$6:E25),\"\")","v":20},"ياسر خليل","مصر","0125787888"]
[null,null,null,{"$f":"IF(E26<>\"\",SUBTOTAL(103,$E$6:E26),\"\")","v":21},"ياسر العربى","مصر","01122558947"]
[null,null,null,{"$f":"IF(E27<>\"\",SUBTOTAL(103,$E$6:E27),\"\")","v":22},"عمر جاد ابونصار","سوهاج","0123446588"]
[null,null,null,{"$f":"IF(E28<>\"\",SUBTOTAL(103,$E$6:E28),\"\")","v":23},"كريم عزت","مصر","0251314558"]
[null,null,null,{"$f":"IF(E29<>\"\",SUBTOTAL(103,$E$6:E29),\"\")","v":24},"ياسر محمد","القاهرة","0231121686"]
[null,null,null,{"$f":"IF(E30<>\"\",SUBTOTAL(103,$E$6:E30),\"\")","v":""}]
[null,null,null,{"$f":"IF(E31<>\"\",SUBTOTAL(103,$E$6:E31),\"\")","v":""}]
[null,null,null,{"$f":"IF(E32<>\"\",SUBTOTAL(103,$E$6:E32),\"\")","v":""}]
[null,null,null,{"$f":"IF(E33<>\"\",SUBTOTAL(103,$E$6:E33),\"\")","v":""}]
[null,null,null,{"$f":"IF(E34<>\"\",SUBTOTAL(103,$E$6:E34),\"\")","v":""}]
[null,null,null,{"$f":"IF(E35<>\"\",SUBTOTAL(103,$E$6:E35),\"\")","v":""}]
[null,null,null,{"$f":"IF(E36<>\"\",SUBTOTAL(103,$E$6:E36),\"\")","v":""}]
[null,null,null,{"$f":"IF(E37<>\"\",SUBTOTAL(103,$E$6:E37),\"\")","v":""}]
[null,null,null,{"$f":"IF(E38<>\"\",SUBTOTAL(103,$E$6:E38),\"\")","v":""}]
[null,null,null,{"$f":"IF(E39<>\"\",SUBTOTAL(103,$E$6:E39),\"\")","v":""}]
[null,null,null,{"$f":"IF(E40<>\"\",SUBTOTAL(103,$E$6:E40),\"\")","v":""}]
[null,null,null,{"$f":"IF(E41<>\"\",SUBTOTAL(103,$E$6:E41),\"\")","v":""}]
[null,null,null,{"$f":"IF(E42<>\"\",SUBTOTAL(103,$E$6:E42),\"\")","v":""}]
[null,null,null,{"$f":"IF(E43<>\"\",SUBTOTAL(103,$E$6:E43),\"\")","v":""}]
[null,null,null,{"$f":"IF(E44<>\"\",SUBTOTAL(103,$E$6:E44),\"\")","v":""}]
[null,null,null,{"$f":"IF(E45<>\"\",SUBTOTAL(103,$E$6:E45),\"\")","v":""}]
[null,null,null,{"$f":"IF(E46<>\"\",SUBTOTAL(103,$E$6:E46),\"\")","v":""}]
[null,null,null,{"$f":"IF(E47<>\"\",SUBTOTAL(103,$E$6:E47),\"\")","v":""}]
[null,null,null,{"$f":"IF(E48<>\"\",SUBTOTAL(103,$E$6:E48),\"\")","v":""}]
[null,null,null,{"$f":"IF(E49<>\"\",SUBTOTAL(103,$E$6:E49),\"\")","v":""}]
[null,null,null,{"$f":"IF(E50<>\"\",SUBTOTAL(103,$E$6:E50),\"\")","v":""}]
[null,null,null,{"$f":"IF(E51<>\"\",SUBTOTAL(103,$E$6:E51),\"\")","v":""}]
[null,null,null,{"$f":"IF(E52<>\"\",SUBTOTAL(103,$E$6:E52),\"\")","v":""}]
[null,null,null,{"$f":"IF(E53<>\"\",SUBTOTAL(103,$E$6:E53),\"\")","v":""}]
[null,null,null,{"$f":"IF(E54<>\"\",SUBTOTAL(103,$E$6:E54),\"\")","v":""}]
[null,null,null,{"$f":"IF(E55<>\"\",SUBTOTAL(103,$E$6:E55),\"\")","v":""}]
[null,null,null,{"$f":"IF(E56<>\"\",SUBTOTAL(103,$E$6:E56),\"\")","v":""}]
[null,null,null,{"$f":"IF(E57<>\"\",SUBTOTAL(103,$E$6:E57),\"\")","v":""}]
[null,null,null,{"$f":"IF(E58<>\"\",SUBTOTAL(103,$E$6:E58),\"\")","v":""}]
[null,null,null,{"$f":"IF(E59<>\"\",SUBTOTAL(103,$E$6:E59),\"\")","v":""}]
[null,null,null,{"$f":"IF(E60<>\"\",SUBTOTAL(103,$E$6:E60),\"\")","v":""}]
[null,null,null,{"$f":"IF(E61<>\"\",SUBTOTAL(103,$E$6:E61),\"\")","v":""}]
[null,null,null,{"$f":"IF(E62<>\"\",SUBTOTAL(103,$E$6:E62),\"\")","v":""}]
[null,null,null,{"$f":"IF(E63<>\"\",SUBTOTAL(103,$E$6:E63),\"\")","v":""}]
[null,null,null,{"$f":"IF(E64<>\"\",SUBTOTAL(103,$E$6:E64),\"\")","v":""}]
[null,null,null,{"$f":"IF(E65<>\"\",SUBTOTAL(103,$E$6:E65),\"\")","v":""}]
[null,null,null,{"$f":"IF(E66<>\"\",SUBTOTAL(103,$E$6:E66),\"\")","v":""}]
[null,null,null,{"$f":"IF(E67<>\"\",SUBTOTAL(103,$E$6:E67),\"\")","v":""}]
[null,null,null,{"$f":"IF(E68<>\"\",SUBTOTAL(103,$E$6:E68),\"\")","v":""}]
[null,null,null,{"$f":"IF(E69<>\"\",SUBTOTAL(103,$E$6:E69),\"\")","v":""}]
[null,null,null,{"$f":"IF(E70<>\"\",SUBTOTAL(103,$E$6:E70),\"\")","v":""}]
[null,null,null,{"$f":"IF(E71<>\"\",SUBTOTAL(103,$E$6:E71),\"\")","v":""}]
[null,null,null,{"$f":"IF(E72<>\"\",SUBTOTAL(103,$E$6:E72),\"\")","v":""}]
[null,null,null,{"$f":"IF(E73<>\"\",SUBTOTAL(103,$E$6:E73),\"\")","v":""}]
[null,null,null,{"$f":"IF(E74<>\"\",SUBTOTAL(103,$E$6:E74),\"\")","v":""}]
[null,null,null,{"$f":"IF(E75<>\"\",SUBTOTAL(103,$E$6:E75),\"\")","v":""}]
[null,null,null,{"$f":"IF(E76<>\"\",SUBTOTAL(103,$E$6:E76),\"\")","v":""}]
[null,null,null,{"$f":"IF(E77<>\"\",SUBTOTAL(103,$E$6:E77),\"\")","v":""}]
[null,null,null,{"$f":"IF(E78<>\"\",SUBTOTAL(103,$E$6:E78),\"\")","v":""}]
[null,null,null,{"$f":"IF(E79<>\"\",SUBTOTAL(103,$E$6:E79),\"\")","v":""}]
[null,null,null,{"$f":"IF(E80<>\"\",SUBTOTAL(103,$E$6:E80),\"\")","v":""}]
[null,null,null,{"$f":"IF(E81<>\"\",SUBTOTAL(103,$E$6:E81),\"\")","v":""}]
[null,null,null,{"$f":"IF(E82<>\"\",SUBTOTAL(103,$E$6:E82),\"\")","v":""}]
[null,null,null,{"$f":"IF(E83<>\"\",SUBTOTAL(103,$E$6:E83),\"\")","v":""}]
[null,null,null,{"$f":"IF(E84<>\"\",SUBTOTAL(103,$E$6:E84),\"\")","v":""}]
[null,null,null,{"$f":"IF(E85<>\"\",SUBTOTAL(103,$E$6:E85),\"\")","v":""}]
[null,null,null,{"$f":"IF(E86<>\"\",SUBTOTAL(103,$E$6:E86),\"\")","v":""}]
[null,null,null,{"$f":"IF(E87<>\"\",SUBTOTAL(103,$E$6:E87),\"\")","v":""}]
[null,null,null,{"$f":"IF(E88<>\"\",SUBTOTAL(103,$E$6:E88),\"\")","v":""}]
[null,null,null,{"$f":"IF(E89<>\"\",SUBTOTAL(103,$E$6:E89),\"\")","v":""}]
[null,null,null,{"$f":"IF(E90<>\"\",SUBTOTAL(103,$E$6:E90),\"\")","v":""}]
[null,null,null,{"$f":"IF(E91<>\"\",SUBTOTAL(103,$E$6:E91),\"\")","v":""}]
[null,null,null,{"$f":"IF(E92<>\"\",SUBTOTAL(103,$E$6:E92),\"\")","v":""}]
[null,null,null,{"$f":"IF(E93<>\"\",SUBTOTAL(103,$E$6:E93),\"\")","v":""}]
[null,null,null,{"$f":"IF(E94<>\"\",SUBTOTAL(103,$E$6:E94),\"\")","v":""}]
[null,null,null,{"$f":"IF(E95<>\"\",SUBTOTAL(103,$E$6:E95),\"\")","v":""}]
[null,null,null,{"$f":"IF(E96<>\"\",SUBTOTAL(103,$E$6:E96),\"\")","v":""}]
[null,null,null,{"$f":"IF(E97<>\"\",SUBTOTAL(103,$E$6:E97),\"\")","v":""}]
[null,null,null,{"$f":"IF(E98<>\"\",SUBTOTAL(103,$E$6:E98),\"\")","v":""}]
[null,null,null,{"$f":"IF(E99<>\"\",SUBTOTAL(103,$E$6:E99),\"\")","v":""}]
[null,null,null,{"$f":"IF(E100<>\"\",SUBTOTAL(103,$E$6:E100),\"\")","v":""}]
[null,null,null,{"$f":"IF(E101<>\"\",SUBTOTAL(103,$E$6:E101),\"\")","v":""}]
[null,null,null,{"$f":"IF(E102<>\"\",SUBTOTAL(103,$E$6:E102),\"\")","v":""}]
[null,null,null,{"$f":"IF(E103<>\"\",SUBTOTAL(103,$E$6:E103),\"\")","v":""}]
[null,null,null,{"$f":"IF(E104<>\"\",SUBTOTAL(103,$E$6:E104),\"\")","v":""}]
[null,null,null,{"$f":"IF(E105<>\"\",SUBTOTAL(103,$E$6:E105),\"\")","v":""}]
[null,null,null,{"$f":"IF(E106<>\"\",SUBTOTAL(103,$E$6:E106),\"\")","v":""}]