Mukamagwira ntchito ndi deta, nthawi zambiri mumayenera kupeza malo omwe chizindikiro chimodzi chimachokera m'ndandanda. Muziwerengero, izi zimatchedwa kuikidwa. Excel ili ndi zida zomwe zimalola ogwiritsa ntchito mwamsanga komanso mosavuta. Tiyeni tiwone momwe tingawagwiritsire ntchito.
Kusankha ntchito
Kuchita masewerowa mu Excel kumapereka mbali yapadera. M'machitidwe akale ogwiritsira ntchito panali woyendetsa mmodzi yemwe anakonzedwa kuthetsa vutoli - Chiwerengero. Kwa zifukwa zogwirizana, zimasiyidwa mu gulu losiyana ndi machitidwe amasiku ano, koma mwa iwo adakali ofunikira kugwira ntchito ndi zifaniziro zatsopano, ngati zili zotheka. Izi zikuphatikizapo owerengetsera owerengetsera. RANG.RV ndi RANG.SR. Tidzakambirana za kusiyana ndi ndondomekoyi yogwirira nawo ntchito patsogolo.
Njira 1: RANK ntchito
Woyendetsa RANG.RV zimagwiritsa ntchito deta ndi zotsatira za selo lomwe limanenedweratu chiwerengero cha ndondomeko yomwe yafotokozedwa kuchokera mndandanda wamakalata. Ngati miyezo ingapo ili ndi msinkhu womwewo, ndiye woyendetsa ntchitoyo amasonyeza kwambiri mndandanda wa zikhalidwe. Ngati, mwachitsanzo, malingaliro awiri ali ofanana, ndiye onse awiri adzapatsidwa chiwerengero chachiwiri, ndipo phindu lotsatira lidzakhala ndi lachinayi. Mwa njira, wogwira ntchito amachita chimodzimodzi. Chiwerengero mu machitidwe akale a Excel, kotero kuti ntchito izi zikhoza kuganiziridwa mofanana.
Chidule cha mawu awa chalembedwa motere:
= RANK RV (chiwerengero; link; [order])
Mikangano "nambala" ndi "link" amafunikanso "lolani" - zosankha. Monga kutsutsana "nambala" Muyenera kulumikizana ndi selo komwe mtengo ulipo, chiwerengero chimene muyenera kudziwa. Kutsutsana "link" lili ndi adiresi ya lonseli yomwe ili payekha. Kutsutsana "lolani" akhoza kukhala ndi matanthauzo awiri - "0" ndi "1". Pachiyambi choyamba, dongosolo la dongosololi likupitirirabe, ndipo lachiwiri - likuwonjezeka. Ngati ndemangayi sinafotokozedwe, ndiye kuti pulogalamuyi ikulingalira ngati pulogalamu yofanana ndi zero.
Fomu iyi ingalembedwe mwachindunji mu selo kumene mukufuna kuti zotsatira zowonjezera ziwonetsedwe, koma kwa ogwiritsa ntchito ambiri ndizosavuta kuyika zolowera kudzera pawindo Oyang'anira ntchito.
- Sankhani selo pa pepala komwe zotsatira za kusinthidwa kwa deta ziwonetsedwe. Dinani pa batani "Ikani ntchito". Ili kumbali yakumanzere ya bar.
- Zochita izi zimayambitsa zenera kuyambira. Oyang'anira ntchito. Icho chimapereka zonse (ndi zosavomerezeka zosiyana) zomwe zingagwiritsidwe ntchito kupanga mawonekedwe mu Excel. M'gululi "Zotsatira" kapena "Mndandanda wathunthu wa alfabeti" pezani dzina "RANK.RV", sankhani ndipo dinani "Bwino".
- Pambuyo pazimene zatchulidwa pamwambapa, ntchito yowonjezera zowonjezera idzayambe. Kumunda "Nambala" lowetsani adiresi ya selo imene mukufuna kuikapo. Izi zikhoza kuchitidwa pamanja, koma ndizosavuta kuzichita monga momwe tafotokozera pansipa. Ikani cholozera mmunda "Nambala", ndiyeno sankhani selo lofunidwa pa pepala.
Pambuyo pake, adiresi yawo idzalowetsedwa kumunda. Mofananamo, timalowa mu deta "Lumikizanani", pokhapokha ngati tikusankha mtundu wonsewo, momwe mkhalidwewu umakhalira.
Ngati mukufuna kuti mndandandawo upite kuchokera kuzing'ono mpaka kuntchito, ndiye kumunda "Dongosolo" ayenera kuyika nambalayi "1". Ngati ndi kofunika kuti dongosolo likhale loperekedwa kuchokera ku zikuluzikulu mpaka zing'onozing'ono (ndipo muyeso yochuluka kwambiri izi ndizofunikira kwenikweni), ndiye munda uwu wassala wopanda kanthu.
Pambuyo pa deta yonseyi ilipo, dinani pa batani "Chabwino".
- Pambuyo pochita zinthu izi, chiwerengero chazotsatira chidzawonetsedwa mu selo lomwe latchulidwa kale, lomwe liri ndi mtengo womwe mwasankha pakati pa mndandanda wonse wa deta.
Ngati mukufuna kufotokoza dera lonselo, simukusowa kulowa mndandanda wapadera wa chizindikiro chilichonse. Choyamba, timapanga adiresi kumunda "Lumikizanani" mtheradi. Onjezani chizindikiro cha dola pamaso pa mtengo uliwonse wogwirizana ($). Pa nthawi yomweyi, sintha zikhulupiliro zomwe zili m'munda "Nambala" Sitiyenera kukhala mwamtheradi, mwinamwake chiwerengerocho chidzawerengedwa molakwika.
Pambuyo pazimenezi, muyenera kuyika cholozera kumbali ya kumanja ya selo, ndipo dikirani kuti chizindikiro chodzaza chiwoneke ngati mawonekedwe a mtanda wawung'ono. Kenaka gwiritsani batani lamanzere ndi kutambasula chikwangwani chomwe chikufanana ndi malo owerengedwa.
Monga mukuonera, motero, ndondomekoyi idzaponyedwa, ndipo mndandandawo udzapangidwira pazomwe zonse za deta.
Phunziro: Wowonjezera Wogwira Ntchito
Phunziro: Mtheradi ndi wachibale zimalumikizana ku Excel
Njira 2: RANK.SR ntchito
Ntchito yachiwiri yomwe ikugwira ntchito mu Excel ndiyi RANG.SR. Mosiyana ndi ntchito Chiwerengero ndi RANG.RV, mwazidzidzidzi wa zikhalidwe zamakono zambiri operekera operekera amapereka gawo limodzi. Izi zikutanthauza kuti ngati miyezo iwiri ili ndi mtengo umodzi ndikutsata mtengowo, iwonso onse adzapatsidwa nambala 2.5.
Syntax RANG.SR zofanana kwambiri ndi mawu apitalo. Zikuwoneka ngati izi:
= RANK.SR (chiwerengero; chiyanjano; [dongosolo])
Fomuyi ingalowetsedwe mwadongosolo kapena kudzera mu wizard. Tidzakhala pamapeto omasulira mwatsatanetsatane.
- Sankhani selo pa pepala kuti muwonetse zotsatira. Mofanana ndi nthawi yoyamba, pitani ku Mlaliki Wachipangizo kudzera mu batani "Ikani ntchito".
- Atatsegula zenera Oyang'anira ntchito timasankha mndandanda wa magulu "Zotsatira" dzina RANG.SR ndipo dinani pa batani "Chabwino".
- Fesholo yotsutsana yatsegulidwa. Zolinga za woyendetsa izi ndi chimodzimodzi ndi ntchito RANG.RV:
- Chiwerengero cha (adilesi ya selo yomwe ili ndi mfundo yomwe mlingo wake uyenera kutsimikiziridwa);
- Yankhulani (zogwirizanitsa zamtunduwu, chiwerengero chomwe chikuchitika);
- Dongosolo (ndemanga yoyenera).
Kulowetsa deta m'minda ndi chimodzimodzi ndi oyendetsa. Pambuyo pokonza zonse, pangani pa batani. "Chabwino".
- Monga momwe mukuonera, zotsatirazi zitatha, zotsatira zowonetsera zinawonetsedwa mu selo lotchulidwa mu ndime yoyamba ya chiphunzitso ichi. Chiwerengero chomwecho ndi malo omwe ali ndi mtengo wapadera pakati pa mfundo zina zamtunduwu. Mosiyana ndi zotsatira RANG.RVchidule cha otsogolera RANG.SR akhoza kukhala ndi mtengo wochepa.
- Monga momwe zinalili ndi ndondomeko yammbuyo, posintha maulumikilo kuchokera ku chizindikiro chokhazikika ndi chowunika, mungathe kuwerengetsa deta yonseyo mwa kudzipiritsa. Zosinthazo ndizo chimodzimodzi.
Phunziro: Zowerengera zina zimagwira ntchito ku Microsoft Excel
Phunziro: Momwe mungapangire autocomplete mu Excel
Monga momwe mukuonera, mu Excel pali ntchito ziwiri zodziwitsa kuyika kwa mtengo wapadera muzinthu zamtundu: RANG.RV ndi RANG.SR. Kwa mapulogalamu akale a pulojekiti, gwiritsani ntchito woyendetsa Chiwerengerozomwe, zenizeni, ndizofanana zogwirizana ndi ntchitoyi RANG.RV. Kusiyana kwakukulu pakati pa mafomu RANG.RV ndi RANG.SR zimakhala kuti woyamba mwa iwo amasonyeza mlingo wapamwamba pamene miyezo ikugwirizana, ndipo yachiwiri amawonetsera chiwerengero chokhala ngati mawonekedwe a decimal. Uwu ndiwo kusiyana kokha pakati pa ogwira ntchitowa, koma ziyenera kuganiziridwa posankha ntchito yomwe wogwiritsa ntchito ayenera kugwiritsira ntchito.
