Urutonde

Mugihe ukorana namakuru, akenshi uvuka kugirango umenye aho bifata murutonde rwigiterane kuri kimwe cyangwa ikindi kimenyetso. Mu mibare, ibi byitwa urwego. Excel ifite ibikoresho byemerera abakoresha vuba kandi byoroshye gutanga ubu buryo. Reka tumenye uko bakoresha.

Urutonde

Ku rutonde muri Excel, imirimo idasanzwe iratangwa. Muri verisiyo ishaje yo gusaba hari uwakoresha umwe wagenewe gukemura iki gikorwa - urwego. Kubigamije guhuza, bisigaye mubyiciro bitandukanye bya formulamo no muri verisiyo zigezweho za gahunda, ariko biracyakira gukorana na analogoues nshya niba hari amahirwe nkaya. Harimo abakoresha imibare rang.rv na rang.sr. Tuzavuga kubyerekeye itandukaniro na algorithm yumurimo nabo.

Uburyo 1: imikorere ya rang.rv

Operator Rang.rv itanga amakuru yo gutunganya amakuru kandi yerekana umubare ukurikirana wimpaka zagenwe kuri selile yerekanwe kurutonde rwimiyoboro. Niba indangagaciro nyinshi zifite urwego rumwe, umukoresha yerekana hejuru yurutonde rwindangagaciro. Niba, kurugero, indangagaciro ebyiri zizagira agaciro kamwe, noneho hazahabwa umubare wa kabiri, kandi agaciro kagaciro kazabona icya kane. By the way, urutonde rwakazi muri verisiyo ishaje ya Excel irasa rwose, kugirango iyi mirimo ishobore gufatwa nkumusaruro.

Syntax yuyu mukoresha yanditse kuburyo bukurikira:

= Rank.rv (umubare; Reba; [gutumiza])

Impaka "Umubare" na "Reba" ni itegeko, na "gahunda" birashoboka. Nkimpaka "umubare" ugomba kwinjiza umurongo ugana selile aho agaciro kirimo umubare ukurikirana ukeneye kumenya. Impaka "Reba" zirimo aderesi yurwego rwose rushyizwe kumurongo. "ITEKA" rishobora kugira ibisobanuro bibiri - "0" na "1". Ku rubanza rwa mbere, kubara itegeko biramanuka, no mu bya kabiri - mu kwiyongera. Niba iyi mpaka idasobanuwe, ihita ifatwa nka zeru.

Iyi formula irashobora kwandikwa intoki, mukagari aho ushaka kwerekana ibisubizo byo gutunganya, ariko kubakoresha benshi biroroshye gushiraho imirimo yihuta mumadirishya yishuri.

1. Tugenera Akagari ku rupapuro Ibisubizo bitunganya amakuru bizerekanwa. Kanda kuri buto "Andika imikorere". Ihari ihatirwa ryimirongo ya formula.
2. Ibi bikorwa biganisha ku kuba imikorere yinzird idirishya ritangira. Irimo ibishoboka byose (kubidasanzwe) abakora bishobora gukoreshwa mugukusanya formulaire muri excel. Muri icyiciro "Urutonde rwinyuguti" cyangwa "Urutonde rwuzuye" dusangamo izina "Rang.rv", turatanga hanyuma ukande kuri buto "OK".



3. Nyuma yibikorwa byavuzwe haruguru, imikorere yimikorere izakorwa. Muri "umubare", andika aderesi ya selire, amakuru ushaka kurubuga. Ibi birashobora gukorwa intoki, ariko biroroshye gukora muburyo bizaganirwaho hepfo. Dushiraho indanga muri "Umubare", hanyuma uhitemo gusa selile wifuza kurupapuro.

   Nyuma yibyo, aderesi yayo izashyirwa kurutonde mumurima. Muri ubwo buryo, twinjiza amakuru no mumirongo "ihuza", gusa muriki gihe bitanga intera yose, murwego rubaho.

   Niba ushaka ko urutonde ruva munsi yacyo, hanyuma murutonde rwa "ruteka" rugomba gushyirwaho "1". Niba ari ngombwa ko itegeko ritangwa rirushijeho kuba muto (kandi mumibare myinshi ikenewe ko ari ngombwa), hanyuma uyu murima usigaye).

   Nyuma yamakuru yose yavuzwe haruguru akorwa, kanda buto "OK".



4. Nyuma yo gukora ibi bikorwa mu kagari kateganijwe mbere, nimero ikurikiranye izerekanwa, ifite agaciro kahisemo murutonde rwose rwamakuru.

   

   Niba ushaka kuyobora ahantu hose wagenwe, ntukeneye kwinjiza formulaire itandukanye kuri buri kimenyetso. Mbere ya byose, dukora aderesi murwego rwa "Ihuza". Mbere ya buri agaciro gakomeye, ongeraho ikimenyetso cyamadorari ($). Muri icyo gihe, guhindura indangagaciro muri "Umubare" rwose, ntakibazo gikwiye, ubundi formula izabarwa nabi.

   

   Nyuma yibyo, ugomba gushiraho indanga mugice cyo hepfo iburyo bwa selire, hanyuma utegereze isura yubwiza bwuzuye muburyo bwumusaraba muto. Noneho vuga buto yimbeba yibumoso hanyuma urambure ikimenyetso kibangikanye ahantu habazwe.

   

   Nkuko tubibona, bityo, formula izandukurwa, kandi urutonde ruzangizwa kumakuru yose.

Isomo: Umukozi wa Wizard muri Excel

Isomo: Ihuza ryuzuye kandi ugereranije kuri Excel

Uburyo 2: Imikorere Ryiza.sr

Igikorwa cya kabiri gitanga imikorere yurutonde muri Excele ni stark.sr. Bitandukanye n'imikorere y'urwego no ku rwego.rv, hamwe n'imikino y'indangagaciro z'ibintu byinshi, uyu mukoresha atanga urwego rusanzwe. Nibyo, niba indangagaciro ebyiri zifite agaciro kangana hanyuma ukurikire ku gaciro kuri numero 1, hanyuma byombi bizahabwa nimero 2.5.

Syntax urwego. SR irasa cyane nigishushanyo cyumukoresha wabanjirije. Asa n'ayo:

= Stak.sr (umubare; Reba; [gutumiza])

Formula irashobora kwinjizwa intoki cyangwa binyuze mubikorwa shobuja. Muri verisiyo yanyuma tuzahagarara byinshi kandi tugatura.

1. Dutanga guhitamo selile kurupapuro kugirango tuvuge ibisubizo. Muri ubwo buryo, nko mugihe cyashize, jya kumurongo wizard unyuze kuri buto "Shyiramo imikorere".
2. Nyuma yo gufungura idirishya rya Wizard Wizard, tugenera izina rya "staristi" "Izina ryibarurishamibare", hanyuma ukande buto "OK".



3. Idirishya ry'impaka rirakorwa. Impaka zuyu mukoresha ni kimwe nimikorere Rang.rv:
   • Umubare (Aderesi ya selile irimo ikintu urwego agomba kugenwa);
   • Reba (urutonde ruhuza, urutonde rwimbere rukorwa);
   • Gutumiza (impaka zidateganijwe).

   Gukora amakuru mumurima bibaho muburyo bumwe nko mumukoresha wabanjirije. Nyuma yimiterere yose ikorwa, kanda kuri buto "OK".



4. Nkuko dushobora kubibona, nyuma y'ibikorwa byuzuye, ibisubizo byo kubara byagaragaye mu Kagari birangwa mu gika cya mbere cyayi mabwiriza. Igisubizo ubwacyo ni ahantu hafite agaciro gakomeye mu zindi ndangagaciro. Bitandukanye nibisubizo, rang.rv, ibisubizo byurwego rwo gufata umurongo. Cer irashobora kugira agaciro gaciriritse.



5. Kimwe na formula ibanza, muguhindura amahuza kuri mwene wabo byuzuye kandi ikimenyetso, amakuru yose yamakuru arashobora gukoreshwa na auto-yuzuye. Algorithm yibikorwa nukuri.

Isomo: Ibindi bikorwa byibarurishamibare muri Microsoft Excel

Isomo: Nigute ushobora gukora Auto-Kuzuza Excel

Nkuko mubibona, hari imikorere ibiri kugirango umenye urutonde rwagaciro kamwe mumakuru: RAng.rv na Rank.S. Kubindi bishaje bya Porogaramu, umukoresha ukoreshwa umwuga akoreshwa, mubyukuri ari ikigereranyo cyuzuye cyimikorere ya ROG.RV Itandukaniro nyamukuru riri hagati ya formula rang.rv na Rank.Sras nuko uwambere muri bo yerekana urwego rwo hejuru hamwe no guhura nindangagaciro, naho icya kabiri cyerekana impuzandengo muburyo bwigice cyaka. Iri ni ryo tandukaniro ryonyine hagati yabakoresha, ariko igomba kwitabwaho mugihe uhisemo neza imikorere umukoresha aribyiza kubikoresha.