SEARCH ntchito mu Microsoft Excel

Mmodzi wa ogwiritsa ntchito otchuka pakati pa ogwiritsa ntchito Excel ndi ntchitoyo Sakani. Ntchito zake zimaphatikizapo kudziwa kuchuluka kwa chinthucho mumtundu wazidziwitso zopatsidwa. Zimabweretsa phindu lalikulu mukamagwiritsa ntchito limodzi ndi ena. Tiyeni tiwone zomwe zimapanga ntchito. Sakani, ndi momwe angagwiritsidwire ntchito pochita.

Kugwiritsa kwa SEARCH

Wogwiritsa ntchito Sakani ndi gawo la ntchito Malingaliro ndi Kufika. Imafufuza zinthu zomwe zidasungidwa mumitundu yosiyanasiyana ndikuyika mu gulu lina kuchuluka kwa malo ake pamlingo uwu. Kwenikweni, ngakhale dzina lake limawonetsa izi. Komanso, ntchitoyi, ikagwiritsidwa ntchito limodzi ndi ena ogwira ntchito, imawauza mtundu wa chinthu chomwe chimafunikira pambuyo pake pokonza izi.

Ntchito Syntax Sakani zikuwoneka ngati:

= SEARCH (search_value; lookup_array; [match_type])

Tsopano lingalirani chilichonse mwa mfundo zitatuzi mosiyana.

"Kufunafuna mtengo" - Ichi ndiye chinthu choyenera kupezeka. Itha kukhala ndi mawonekedwe, manambala, komanso imakhala ndi mtengo womveka. Kungonena za khungu lomwe lili ndi chilichonse chamtengo wapatali pamwambapa kumathandizanso kutsutsana.

Wawonedwa ndiye adilesi ya mtundu womwe mtengo wa kusaka umapezeka. Ndi malo a izi mwanjira iyi omwe wothandizira akuyenera kudziwa Sakani.

Mtundu Wofananira ikuwonetsa kufanana komwe muyenera kuyang'ana kapena kolakwika. Kutsutsana kumatha kukhala ndi matanthawu atatu: "1", "0" ndi "-1". Pamtengo "0" wothandizira amangofufuza zofananira. Ngati mtengo wake wafotokozedwa "1", ndiye pakalibe mechi chofanana Sakani imabweza chinthu chomwe chili pafupi nacho kuti chatsike. Ngati mtengo wake wafotokozedwa "-1", ndiye ngati palibe mechi yeniyeni yomwe yapezeka, ntchitoyo imabweza chinthu chomwe chapafupi kwambiri kuti chikwere. Ndikofunikira ngati simukufuna kudziwa zenizeni, koma za mtengo woyeneranso kuti makulidwe omwe mukuwawona akukonzedwa mwanjira yakukwera (mtundu wofananira "1") kapena kutsika (mtundu wa machesi "-1").

Kukangana Mtundu Wofananira osafunikira. Itha kusiyidwa ngati sikofunikira. Poterepa, phindu lake ndi "1". Ikani mkangano Mtundu WofananiraChoyambirira, zimamveka pokhapokha ngati manambala akukonzedwa, osati amawu.

Ngati Sakani pazokhazikitsidwa sangapeze zomwe mukufuna, wothandizira akuwonetsa cholakwika mu foni "# N / A".

Mukasaka, wothandizira sakusiyanitsa pakati pa mayina amilandu. Ngati pali machesi angapo enieni mndandanda, ndiye Sakani amawonetsa malo oyamba a iwo mu cell.

Njira 1: onetsani malo omwe muli zambiri zomwe zalembedwa

Tiyeni tiwone chitsanzo cha chophweka mlandu mukamagwiritsa ntchito Sakani Mutha kudziwa komwe kuli zinthu zomwe zapezeka muzosanjidwa zambiri. Timazindikira malo omwe mawuwo akukhala mndandanda womwe mayina opanga amapezeka Shuga.

1. Sankhani khungu lomwe zotsatira zomwe zakonzedwa ziwonetsedwa. Dinani pachizindikiro "Ikani ntchito" pafupi ndi mzere wa njira.



2. Kuyambira Ogwira Ntchito. Gulu lotseguka "Mndandanda wathunthu wa zilembo" kapena Malingaliro ndi Kufika. Pamndandanda wa ogwiritsira ntchito tikuyang'ana dzinalo "Sakani". Popeza mwapeza ndikuwonetsa, dinani batani "Zabwino" pansi pazenera.



3. Window Yogwira Ntchito Yoyatsidwa Sakani. Monga mukuwonera, pazenera ili, mwa kuchuluka kwa zokangana, pali magawo atatu. Tiyenera kuwadzaza.

   Popeza tiyenera kupeza malo a mawu Shuga pamtundu, ndiye ikani dzina ili kumunda "Kufunafuna mtengo".

   M'munda Wawonedwa muyenera kufotokozera zogwirizanitsa za mtundu womwewo. Mutha kuyendetsa pamanja, koma ndikosavuta kuyika kalozera m'munda ndikusankha chida ichi papepala, ndikusunga batani lakumanzere. Pambuyo pake, adilesi yake iwonetsedwa pazenera la zotsutsa.

   M'munda wachitatu Mtundu Wofananira ikani nambala "0", popeza tidzagwira ntchito ndi zolembalemba, chifukwa chake tikufuna zotsatira zolondola.

   Pambuyo poti datha yonse yaikidwa, dinani batani "Zabwino".



4. Pulogalamuyi imawerengera ndipo ikuwonetsa kuchuluka kwa chosankha Shuga m'magawo osankhidwa omwe mu cell tidatchulapo gawo loyamba la malangizowa. Nambala yaudindo izikhala yolingana "4".

Phunziro: Excel Feature Wizard

Njira 2: makina ogwiritsa ntchito SEARCH

Pamwambapa, tidasanthula nkhani yakale kwambiri yogwiritsa ntchito wothandizira Sakanikoma ngakhale imatha kukhala yokha.

1. Kuti zitheke, onjezani minda ina iwiri papepala: Dongosolo ndi "Chiwerengero". M'munda Dongosolo pagalimoto mdzina lomwe muyenera kupeza. Tsopano zikhale choncho Nyama. M'munda "Chiwerengero" ikani cholozera ndikupita pawindo laopanikizika monga momwe tafotokozera pamwambapa.



2. Pa zenera zotsutsana ndi ntchito, m'munda "Kufunafuna mtengo" sonyezani adilesi yomwe foniyo yalembedwa Nyama. M'minda Wawonedwa ndi Mtundu Wofananira fotokozerani zomwezo monga momwe zidalili kale - ma adilesi ndi nambala "0" motero. Pambuyo pake, dinani batani "Zabwino".



3. Tikatha kuchita izi pamwambapa "Chiwerengero" malo amawu awonetsedwa Nyama mumitundu yosankhidwa. Pankhaniyi, ndizofanana "3".



4. Njirayi ndi yabwino chifukwa ngati tikufuna kudziwa dzina lina lililonse, sitingafunikenso kusintha kapena kusintha njira iliyonse. Zosavuta m'munda Dongosolo lowetsani mawu ofufuza m'malo mwa woyamba. Kusanthula ndi kutulutsa zotsatira pambuyo izi zidzachitika zokha.

Njira 3: gwiritsani ntchito FIND opanga manambala

Tsopano tiyeni tiwone momwe mungagwiritsire ntchito Sakani pogwira ntchito ndi manambala.

Ntchito yake ndi kupeza katundu mu kuchuluka kwa malonda a ma ruble 400 kapena oyandikira kwambiri ndalamazi kuti akwere.

1. Choyamba, tiyenera kulinganiza zinthu zomwe zili mgululi "Ndalama" pakutsatira dongosolo. Sankhani gawo ili ndikupita ku tabu "Pofikira". Dinani pachizindikiro Sanjani ndi Fyulutaili pa tepi mu block "Kusintha". Pamndandanda womwe umawonekera, sankhani "Sanjani kuchokera pamwambamwamba kupita pazochepera".



2. Mukamaliza kukonzekera, sankhani selo momwe zotsatirazo zikuwonekere, ndipo yambitsani zenera la mkangano momwe limafotokozedwera njira yoyamba.

   M'munda "Kufunafuna mtengo" kuyendetsa angapo "400". M'munda Wawonedwa tchulani zogwirizanitsa ndi mzati "Ndalama". M'munda Mtundu Wofananira mtengo wokhazikitsidwa "-1", popeza tikufunafuna mitengo yofanana kapena yayikulu kuchokera pakusaka. Mukamaliza kukonza zosintha zonse, dinani batani "Zabwino".



3. Zotsatira zakusintha zikuwonetsedwa mu khungu lomwe lidatchulidwa kale. Awa ndi udindo. "3". Zofanana ndi iye "Mbatata". Zowonadi, kuchuluka kwa ndalama kuchokera pakugulitsidwa kwazinthu izi ndizomwe zili pafupi kwambiri ndi chiwerengero cha 400 mukukwera mtengo ndipo zimakhala ma ruble 450.

Mofananamo, mutha kusanthula malo apafupi kwambiri "400" pakutsatira dongosolo. Pokhapokha pazenera muyenera kusefa data kuti mukwere, ndikugulitsa m'munda Mtundu Wofananira ntchito mikangano yokhazikika "1".

Phunziro: Sanjani ndi kusefa deta mu Excel

Njira 4: gwiritsani ntchito limodzi ndi ena ogwira ntchito

Ndizothandiza kwambiri kugwiritsa ntchito ntchitoyi ndi ogwiritsa ntchito ena ngati njira imodzi yovuta. Nthawi zambiri imagwiritsidwa ntchito molumikizana ndi ntchito INDEX. Kutsutsana uku kukuwonetsa zomwe zili mumtundu womwe wafotokozedwa ndi mzere wake kapena nambala ya mzere mu foni yomwe idatchulidwa. Komanso kuwerengera, monga kwa operekawo Sakani, imagwiridwa kuti siyofanana ndi pepala lonse, koma kokha pamtunduwo. Syntax yantchitoyi ndi motere:

= INDEX (mndandanda;

Komanso, ngati gulu ndilofanana, mutha kugwiritsa ntchito mfundo imodzi yokha: Nambala ya mzere kapena Chiwerengero Cha Column.

Mbali Yogwirizanitsa INDEX ndi Sakani Gona kuti omaliza angagwiritsidwe ntchito ngati mkangano woyamba, ndiye kuti akuwonetsa malo mzere kapena mzati.

Tiyeni tiwone momwe izi zitha kuchitidwira poyeserera kugwiritsa ntchito tebulo lonse. Ntchito yathu ndikuwonetsa mumunda wowonjezera wa pepalalo "Zogulitsa" dzina la malonda, kuchuluka kwathunthu kwa ndalama zomwe ndi ma ruble 350 kapena oyandikira kwambiri ndi kufunika kwake. Kutsutsana kuno kwatchulidwa pamunda. "Kuchuluka kwa ndalama patsamba lililonse".

1. Sanjani zinthu mumkhola "Ndalama Zopeza" kukwera. Kuti muchite izi, sankhani mzere wofunikira ndipo, kukhala tabu "Pofikira"dinani pachizindikiro Sanjani ndi Fyuluta, kenako pa menyu omwe akuwonekera, dinani pazinthuzo "Sanjani kuchokera kocheperako mpaka pamlingo wambiri".



2. Sankhani khungu m'munda "Zogulitsa" ndi kuyimba Fotokozerani Wizard mwa njira yanthawi yonse kudzera pa batani "Ikani ntchito".



3. Pazenera lomwe limatseguka Ogwira Ntchito m'gulu Malingaliro ndi Kufika kufunafuna dzina INDEX, sankhani ndikudina batani "Zabwino".



4. Kenako, zenera limatseguka lomwe limapereka kusankha kwa wosankha INDEX: kwa mndandanda kapena kalozera. Tikufuna njira yoyamba. Chifukwa chake, timasiya pazenera ili zonse zosintha ndikudina batani "Zabwino".



5. Ntchito yotsutsana ndi ntchito imatsegulidwa INDEX. M'munda Menya fotokozerani adilesi yamagulu omwe othandizira ali INDEX adzafufuza dzina la malonda ake. M'malo mwathu, iyi ndi mzati "Zogulitsa".

   M'munda Nambala ya mzere ntchito yosanjidwa idzakhalapo Sakani. Iyenera kuyendetsedwa pamanja pogwiritsa ntchito syntax yomwe yatchulidwa kumayambiriro kwa nkhaniyo. Nthawi yomweyo lembani dzina la ntchitoyi - "Sakani" opanda mawu. Kenako tsegulani bulaketi. Mtsutso woyamba kwa operekera ntchito ndi "Kufunafuna mtengo". Ili pa pepala m'munda "Zowerengeka zenizeni". Fotokozani zogwirizanitsa za selo lomwe lili ndi nambala 350. Timayika semicolon. Mtsutso wachiwiri ndi Wawonedwa. Sakani tiwona magawo omwe kuchuluka kwa ndalama kumakhazikitsidwa ndikuyang'ana omwe ali pafupi ndi ma ruble 350. Chifukwa chake, pankhaniyi, tchulani maumbali azigawo "Ndalama Zopeza". Apanso tikuika semicolon. Mtsutso wachitatu ndi Mtundu Wofananira. Popeza tifufuza nambala yolingana ndi yomwe yapatsidwa kapena yocheperako, timayika nambala apa "1". Timatseka mabatani.

   Mtsutso wachitatu pa ntchitoyo INDEX Chiwerengero Cha Column siyani kanthu. Pambuyo pake, dinani batani "Zabwino".



6. Monga mukuwonera, ntchitoyo INDEX wogwiritsa ntchito Sakani mu khungu lomwe limanenedweratu limawonetsa dzinalo Tiyi. Zowonadi, kuchuluka kochokera kugulitsa tiyi (ma ruble 300) kuyandikira kwambiri kutsika kuti chiwerengero cha ruble 350 kuchokera pazinthu zonse zomwe zili pagome zikukonzedwa.



7. Ngati tisintha manambala m'munda "Zowerengeka zenizeni" kwa wina, ndiye kuti zomwe zili m'mundamu ziziwerengedwa zokha "Zogulitsa".

Phunziro: INDEX ntchito ku Excel

Monga mukuwonera, wothandizira Sakani Ndi ntchito yabwino kwambiri kudziwa chiwerengero cha chinthu chomwe chatchulidwa mumndandanda wazambiri. Koma mapindu ake amachulukirachulukira ngati atagwiritsidwa ntchito m'njira zovuta.