Pogwira ntchito ndi data, nthawi zambiri pamakhala kufunikira kudziwa komwe malo amodzi kapena amodzi amakhala nawo mndandanda wophatikizika malinga ndi kukula kwake. M'mawerengero, izi zimatchedwa udindo. Excel ili ndi zida zomwe zimalola ogwiritsa ntchito kuti azichita njirayi mwachangu komanso mosavuta. Tiyeni tiwone momwe mungazigwiritsire ntchito.
Ntchito zogwirira ntchito
Kuti mugwire udindo mu Excel pali ntchito zapadera. M'matembenuzidwe akale a ntchito, pamakhala wothandizirana m'modzi adapangidwa kuti athetse vuto ili - RANK. Pazolinga zogwirizana, zimasiyidwa pagulu la mitundu komanso momwe ziliri mu pulogalamuyo, komabe ndikofunikira kugwira ntchito ndi zatsopano mwa iwo, ngati zingatheke. Izi zikuphatikiza owerengera. RANK.RV ndi RANK.SR. Tilankhula za kusiyanasiyana ndi ma algorithm ogwira nawo ntchito pambuyo pake.
Njira 1: RANK.RV ntchito
Wogwiritsa ntchito RANK.RV imagwira ntchito ndikuwonetsa mu foni yotsimikizika nambala yotsimikizika ya malingaliro kuchokera pamndandanda wophatikizira. Ngati mitengo ingapo ili ndi mulingo wofanana, ndiye kuti wothandizira akuwonetsa kwambiri kuchokera mndandanda wazikhalidwe. Mwachitsanzo, ngati zinthu ziwiri zili ndi mtengo womwewo, zonsezo zidzapatsidwa nambala yachiwiri, ndipo phindu lalikulu lotsatira lidzakhala ndi gawo linayi. Mwa njira, wothandizirayo amachita chimodzimodzi RANK m'mitundu yakale ya Excel, kotero ntchito izi zitha kuonedwa chimodzimodzi.
Syntax ya mawu awa yalembedwa motere:
= RANK.RV (nambala; chidziwitso; [kulamula])
Mikangano "nambala" ndi kulumikizana amafunikiranso "kulamula" - kusankha. Monga mkangano "nambala" muyenera kuyika ulalo wa foni yomwe ili ndi phindu, nambala yomwe muyenera kudziwa. Kukangana kulumikizana ili ndi adilesi ya gulu lonse lomwe lawerengedwa. Kukangana "kulamula" ikhoza kukhala ndi matanthauzo awiri - "0" ndi "1". Poyambirira, madongosolo amawerengedwa, ndipo chachiwiri, kukwera. Ngati mkanganowu sunatchulidwe, ndiye kuti umangowona ngati pulogalamuyo ndi zero.
Fomira iyi imatha kulembedwa pamanja mu foni momwe mukufuna zotsatira zake ziwonekere, koma kwa owerenga ambiri ndizosavuta kuyikapo zofunikira pazenera Ogwira Ntchito.
- Timasankha papepala khungu lomwe zotsatira za kusanthula deta zidzawonetsedwa. Dinani batani "Ikani ntchito". Chawonetsedwa kumanzere kwa baramu yamu formula.
- Machitidwe awa amachititsa kuti zenera liyambe. Ogwira Ntchito. Imakhala ndi othandizira onse (kupatula zina) omwe mungagwiritse ntchito kupanga mitundu mu Excel. Gulu "Zowerengera" kapena "Mndandanda wathunthu wa zilembo" pezani dzinali "RANK.RV", sankhani ndikudina batani "Chabwino".
- Pambuyo pazomwe tatchulazi, zenera zotsutsa ntchito zitha kuyambitsidwa. M'munda "Chiwerengero" lowetsani adilesi ya foni momwe deta yomwe mukufuna kuikidwa. Izi zitha kuchitika pamanja, koma ndichosavuta kuchita m'njira yomwe ifotokozeredwa pansipa. Khazikitsani chotembezera m'munda "Chiwerengero", kenako mungosankha khungu lomwe mukufuna
Pambuyo pake, adilesi yake imalowetsedwa kumunda. Mwanjira yomweyo timalowetsa deta m'munda Lumikizani, pokhapokha pamenepa timasankha mtundu wonse momwe masanjidwewo amachitikira.
Ngati mukufuna kuti maudindo azichitika kuyambira ang'ono mpaka akulu kwambiri, ndiye kuti m'munda "Order" chithunzi chiyenera kukhazikitsidwa "1". Ngati mukufuna kuti malamulowo agawidwe kuyambira akulu kupita ang'ono (ndipo nthawi zambiri izi ndizomwe zikufunika), ndiye siyani malo opanda kanthu.
Pambuyo polemba deta yonse pamwambapa, dinani batani "Zabwino".
- Mukamaliza kuchita izi mu khungu lomwe limanenedwa kale, nambala ya seriyo idzawonetsedwa yomwe ili ndi phindu lomwe mwasankha pakati pa mindandanda yonse ya data.
Ngati mukufuna kugawa dera lonselo, ndiye kuti simukufunikira kuyika njira ina iliyonse chosakanizira. Choyamba, chitani adilesi m'munda Lumikizani mtheradi. Pamaso pa mgwirizano uliwonse, onjezani chikwangwani cha dola ($). Nthawi yomweyo, sinthani zofunikira pamunda "Chiwerengero" Mtheradi suyenera kukhalapo, apo ayi mafotokozedwewo sawerengedwa molondola.
Pambuyo pake, muyenera kuyika chowunkhira ngodya ya m'munsi chakumanja, ndikudikirira kuti chizindikirocho chizaze mawonekedwe. Kenako gwiritsani batani lamanzere lakumanzere ndikukoka chikhomo chomwe chikufanana ndi dera lawerengedwa.
Monga mukuwonera, mwanjira iyi amawongolera, ndipo mawonekedwe adzachitika pang'onopang'ono lonse la deta.
Phunziro: Ntchito Wizard ku Excel
Phunziro: Zolumikizana kwathunthu ndi abale ku Excel
Njira 2: ntchito ya RANK.S.R.
Ntchito yachiwiri yomwe imagwira ntchito ku Excel udindo ndi RANK.SR. Mosiyana ndi ntchito RANK ndi RANK.RV, ngati zinthu zingapo zikugwirizana, wothandizayu amapereka mulingo wapakati. Ndiye kuti, ngati mfundo ziwiri zili zofanana ndikutsatira mtengo womwe uli pansi 1, onsewo azigawiridwa manambala 2,5.
Syntax RANK.SR zofanana kwambiri ndi chithunzi cha mawu am'mbuyomu. Zikuwoneka ngati:
= RANK.SR (nambala; chidziwitso; [kulamula])
Fomula imatha kutumizidwa pamanja kapena kudzera pa Ntchito Wizard. Tikambirana pankhani yomaliza mwatsatanetsatane.
- Timasankha khungu papepala kuti muwonetse zotsatira. Mwanjira yomweyo ndi nthawi yapita, pitani Fotokozerani Wizard kudzera pa batani "Ikani ntchito".
- Pambuyo potsegula zenera Ogwira Ntchito sankhani magulu mndandanda "Zowerengera" dzina RANK.SR ndipo dinani batani "Zabwino".
- Zenera lotsutsana limayambitsidwa. Zotsutsana za opaleshoni iyi ndizofanana ndendende ndi ntchitoyo RANK.RV:
- Chiwerengero (adilesi ya foni yomwe ili ndi gawo lomwe mulingo wake uyenera kutsimikiziridwa);
- Lumikizani (zofananira zamtundu, udindo womwe umachitika);
- Dongosolo (mwadala wosankha).
Kulowetsa zidziwitso m'minda kumachitika ndendende monga momwe zimakhalira ndi opareshoni yoyamba. Pambuyo poti makonzedwe onse athe, dinani batani "Zabwino".
- Monga mukuwonera, masitepe atachitika, zotsatira zowerengera zidawonetsedwa mu khungu lomwe lidalembedwa gawo loyamba la malangizowa. Zotsatira zake zokha ndi malo omwe amakhala ndi mtengo wake pakati pa mitundu ina ya pamulingo. Mosiyana ndi zotsatira zake RANK.RVchidule RANK.SR ikhoza kukhala ndi tanthauzo lozungulira.
- Monga momwe zimakhalira ndi kachitidwe kam'mbuyomu, posintha maulalo kuchokera pa wachibale kupita ku mtheradi ndikuwunikira zolemba, pogwiritsa ntchito autocomplete mutha kuwongolera zosankha zonse. Momwe machitidwe amachitidwe alili ofanana.
Phunziro: Ntchito zina zowerengera mu Microsoft Excel
Phunziro: Momwe mungapangire kuti zitheke mu Excel
Monga mukuwonera, mu Excel pali zinthu ziwiri zofunikira pakuwona mtundu wa mtengo wake pamasamba osiyanasiyana: RANK.RV ndi RANK.SR. Mwa mitundu yakale ya pulogalamuyo, wothandizirayo amagwiritsidwa ntchito. RANK, pomwe, ndizofanizira kwathunthu kwa ntchitoyo RANK.RV. Kusiyana kwakukulu pakati pa njira RANK.RV ndi RANK.SR imakhala kuti yoyamba imawonetsa mkulu kwambiri pamene mfundozo zikugwirizana, ndipo chachiwiri chikuwonetsa chizindikiro chazomwe zili ngati chigawo chomaliza. Uku ndikusiyana pakati pa ogwiritsira ntchito awa, koma kuyenera kukumbukiridwa posankha ntchito yomwe wogwiritsa ntchito agwiritse ntchito.
