Kuti uwane kukosha kwesero iri pamharadzano yekoramu uye mutsara mune tafura dhairekitori muMicrosoft Office Excel, iwe unofanirwa kushandisa iyo "INDEX" basa, pamwe neanobatsira "SEARCH". Kuwana kukosha muhurongwa kunodiwa apo mushandisi anoshanda netafura huru, uye anoda "kudhonza" mutsara we data. Ichi chinyorwa chinotarisa yakadzama algorithm yekushandisa iyo "INDEX" basa rekutsvaga kukosha muhurongwa.
Kurekodha "INDEX" basa
Array operator yakadaro yakanyorwa sezvinotevera: = INDEX(kuronga; nhamba yemutsara; nhamba yekoramu). Panzvimbo pemashoko ari mumabhuraketi, nhamba dzinoenderana dzemasero ari patafura yepakutanga dzinoratidzwa.
Kurekodha basa re "MATCH".
Uyu mubatsiri mushandisi webasa rekutanga, iro rinozoshandiswa zvakare kana uchitarisa kumusoro ukoshi muhurongwa. Chinyorwa chayo muExcel chinotaridzika seizvi: = MATCH(kukosha kuwana; tafura array; match type).
Teerera! Kana uchinyora nharo dzebasa reINDEX, nhamba yekoramu ndeyekusarudza.
Nzira yekuwana sei kukosha mune array
Kuti unzwisise musoro wenyaya, iyo algorithm yekuita basa inofanirwa kutariswa uchishandisa chaiyo muenzaniso. Ngatigadzirei tafura yemirairo muExcel kwezuva rimwe chete, umo muchava nemakoramu: "nhamba yekuraira", "Mutengi", "Chigadzirwa", "Chimiro", "Mutengo weyuniti", "Mari". Iwe unofanirwa kuwana kukosha muhurongwa, kureva kugadzira kadhi remutengi wega wega kuitira kuti uwane ruzivo mune yakamanikidzwa fomu kubva kumaseru etafura yekutanga.
Kuti uite izvi, iwe unofanirwa kuita nhevedzano yezviito zvinoenderana neiyo algorithm:
- Gadzira kadhi rekodhi revatengi.
- Kune mutsara wekutanga wekadhi, unofanirwa kugadzira rondedzero yekudonhedza pasi umo mazita evatengi kubva kune chikuru array achanyorwa. Zvadaro, nekusarudza rimwe zita, mushandisi achaona ruzivo rwakakwana pairi, iro rinozoratidzwa mune mamwe mitsara yekadhi rekodhi.
- Isa mutsara wemouse mumutsara wekutanga wekadhi uye pinda chikamu che "Data" kumusoro kwemenyu huru yepurogiramu.
- Dzvanya bhatani re "Data Validation".
- Muhwindo rinoonekwa, mundima ye "Data type", sarudza "Rondedzero" sarudzo, uye sarudza huwandu hwemasero ekutanga array seyakabva, umo mazita evatengi vose akanyoreswa.
- Museve uchaonekwa kurudyi rwesero muchikamu chekutanga chekadhi. Kana ukadzvanya pairi, unogona kuona runyoro rwevatengi vese. Pano iwe unofanirwa kusarudza chero mutengi.
- Mumutsara we "order number" nyora basa racho «=INDEX(», wobva wadzvanya pa “fx” icon padivi peExcel formula bar.
- Mune iyo Function Wizard menyu inovhura, sarudza iyo array fomu ye "INDEX" basa kubva pane iyo runyorwa uye tinya pakanzi "OK".
- Iwindo re "Function Arguments" richazarura, umo iwe unoda kuzadza mitsara yose, ichiratidza mitsara inowirirana yemasero.
- Kutanga iwe unofanirwa kudzvanya pane iyo icon yakatarisana ne "Array" ndima uye sarudza iyo yepakutanga ndiro pamwe chete nemusoro.
- Mumunda "Mutsara nhamba" unoda kuzadza basa "MATCH". Munzvimbo yekutanga muvabereki, sekupokana, tinoratidza zita remutengi rakasarudzwa mukadhi rekuraira. Seyechipiri gakava re "MATCH" basa, iwe unofanirwa kutsanangura huwandu hwese hwevatengi mune yekutanga tafura tafura. Panzvimbo yenharo yechitatu, iwe unofanirwa kunyora nhamba 0, nekuti ichatsvaga chaiyo mechi.
Zvinokosha! Mushure mekuzadza chinhu chimwe nechimwe che "MATCH" basa, unozofanirwa kudzvanya bhatani re "F4" kuti uturike zviratidzo zvemadhora pamberi pemutambi wega wega munharo. Izvi zvinobvumira iyo fomula kuti irege "kubuda" mukuita kwekuuraya.
- Mumutsara we "Column number" nyora zvakare basa rekubatsira "MATCH" nenharo dzakakodzera.
- Senharo yekutanga yebasa racho, unofanirwa kutsanangura sero isina chinhu mumutsara we "Chigadzirwa" mukadhi reodha. Panguva imwecheteyo, hazvichadi kuti urembedze zviratidzo zvemadhora pamakakatanwa, nekuti gakava rinodiwa rinofanira "kutenderera".
- Kuzadza nharo yechipiri ye "MATCH" basa, unoda kusarudza musoro wezvinyorwa zvinyorwa, uye wobva wadzvanya bhatani re "F4" kugadzirisa mavara.
- Senharo yekupedzisira, iwe unofanirwa kunyora 0, kuvhara bhuraketi uye tinya pakanzi "OK" pazasi pebhokisi re "Function Arguments". Mumamiriro ezvinhu aya, nhamba 0 inonyatsoenderana.
- Tarisa mhinduro. Mushure mekuita zviito zvakareba zvakadaro, nhamba inoenderana nemutengi akasarudzwa inofanira kuratidzwa mumutsara we "order number".
- Padanho rekupedzisira, fomula ichada kutambanudzirwa kumaseru ese eiyo kadhi rekuraira kusvika kumagumo kuitira kuzadza mitsara yasara.
Mamwe Mashoko! Kana mutengi asarudzwa kubva pakudonhedza pasi kwekadhi reodha, ruzivo rwese pamunhu uyu rucharatidzwa mumitsara yasara yehurongwa.
mhedziso
Saka, kuti uwane kukosha kwaunoda muhurongwa muMicrosoft Office Excel, mushandisi achafanira kuita basa rakawanda. Nekuda kweizvozvo, diki data plate inofanirwa kuwanikwa, iyo inoratidza yakamanikidzwa ruzivo kune yega yega parameter kubva kune yekutanga array. Iyo nzira yekutsvaga kukosha nemifananidzo inoenderana yakakurukurwa zvakadzama pamusoro.