Excel Ranking

Kana uchishanda nedata, zvinowanzomuka kukosha kwekutsvaga iyo nzvimbo iyo yainotora mune yakaunganidzwa rondedzero yeimwe kana chimwe chiratidzo. Muhuwandu, izvi zvinonzi chinzvimbo. Excel ine maturusi anobvumira vashandisi kukurumidza uye nyore kuburitsa maitiro aya. Ngatitsvagei kuti vangashandise sei.

Mabasa Anoshanda

Yekunamatira muExcel, mabasa akakosha anopiwa. Mune shanduro dzekare dzekushandisa pakanga paine mumwe mushanduri akagadzirirwa kugadzirisa basa iri - chinzvimbo. Zvekuita zvinangwa zvakaenzana Izvi zvinosanganisira vatambi vekare Rang.rv naRang.sr..sr..sr. Tichataura nezve misiyano uye algorithm yekushanda navo.

Nzira 1: Rang.rv Basa

Operater Rang.rv inoburitsa data yekugadzirisa uye inoratidza iyo nhamba yekutevedzana yeiyo yakataurwa nharo kune iyo yakatarwa sero kubva kuCumbulive rondedzero. Kana huwandu hwakawanda huve hwakaenzana, anoshanda anoratidza yakakwirira yerondedzero yetsika. Kana, semuenzaniso, tsika mbiri dzichava nemhando imwechete, ipapo vese vachapihwa nhamba yechipiri, uye kukosha kwekukosha kuchawana chechina. Nenzira, iyo inoshanda chinzvimbo mune shanduro dzekare dzeKubatsiri zvakangofanana, zvekuti mabasa aya anogona kutariswa zvakafanana.

Iyo syntax yeiyi oparesheni yakanyorwa seinotevera:

= Rank.rv (nhamba; Reference; [Order])

Nhaurwa "nhamba" uye "Revhisi" inosungirwa, uye "kurongeka" inosarudzika. Sekupokana "nhamba" iwe unofanirwa kuisa chinongedzo kuchitokisi uko kukosha kwacho kuve nehuwandu hwehuwandu hwenyu iwe unofanirwa kuziva. Iyo "Revhitiko" nharo ine kero yehuwandu hwese hwakaiswa. "Order" gakava inogona kunge iine zvirevo zviviri - "0" uye "1". Muchiitiko chekutanga, kuverenga kweiyo odhi iri kuburuka, uye mune yechipiri - nekuwedzera. Kana kupokana uku kusingataurwe, kunoonekwa zvoga kuve zero.

Iyi formula inogona kunyorwa mumanzwiro, muchitokisi kwaunoda kuratidza mhedzisiro yekugadzirisa, asi kune vazhinji vashandisi zvakanakira kuisa mabasa ewazard hwindo.

1. Isu tinopa iyo sero pane iyo iyo iyo data yekugadzirisa data icharatidzwa. Dzvanya pane bhatani "Paste basa". Izvo zvinowanikwa kuruboshwe rwetambo ye formula.
2. Izvi zviito zvinotungamira kuchokwadi chekuti mabasa eWizard Window anotanga. Iyo ine zvese (yekusarudzika zvisingaverengeki) vashandisi vanogona kushandiswa kuComple Formulas muExcel. Muchikamu "nhamba" kana "yakazara alfabhethi rondedzero" tinowana zita rekuti "Rang.rv", isu tinogovera uye tinya pane "ok" bhatani.



3. Mushure mekuita zviri pamusoro, nharo dzekuita dzinozoitwa. Mu "nhamba" munda, pinda iyo kero yeiyo cell, iyo data mauri yaunoda kukwira. Izvi zvinogona kuitwa pamurume, asi zviri nyore kuita nenzira iyo ichakurukurwa pazasi. Isu tinosimbisa iyo yekutsikisa mu "nhamba" munda, uye wobva wangosarudza sero raunoda pabepa.

   Mushure meizvozvo, kero yayo ichanyorwa mumunda. Nenzira imwecheteyo, isu tinopinda iyo data uye mune chinongedzo "chinongedzo", chete mune ino kesi kugovera huwandu hwese, mukati merimwe chinzvimbo chinoitika.

   Kana iwe uchida chinzvimbo kuti uuye kubva kune zvishoma kusvika kune zvimwe, saka mu "Order" munda unofanirwa kuiswa "1". Kana zvichidikanwa kuti kurongeka kunogoverwa kubva kuwanda kusvika padiki kusvika padiki

   Mushure mezvese data iri pamusoro rakagadzirwa, tinya iyo "OK" bhatani.



4. Mushure mekuita izvi zviito muchitokisi pre-yakataurwa, nhamba yekutevera icharatidzwa, iyo ine kukosha kwesarudzo yako pakati peiyo rondedzero yese yedata.

   

   Kana iwe uchida kumhanya iyo yakazara nzvimbo yakatarwa, iwe haudi kupinda mune imwe nzvimbo yeChiratidzo chega chega chiratidzo. Chekutanga pane zvese, tinoita kero mu "link" munda. Pamberi pega yega kukosha kukosha, wedzera chiratidzo chedhora ($). Panguva imwecheteyo, kuti uchinje zvinokonzereso mu "nhamba" munda kuti isimbe, pasina mhosva haifanire, nzira iyo formula ichaverengerwa zvisizvo.

   

   Mushure meizvozvo, iwe unofanirwa kuisa iyo yekutsikisa mukona yepazasi kurudyi yechitokisi, uye kumirira kutaridzika kwekuzadza mucherechedzo muchimiro chechidiki. Wobva wachinjisa bhatani rekuruboshwe bhatani uye kutambanudza mucherechedzo wakafanana nenzvimbo yakatarwa.

   

   Sezvatinoona, nokudaro, formula ichapepetwa, uye chinzvimbo chichagadzirwa pane iyo yese data renji.

Chidzidzo: Wizard mabasa muExcel

Chidzidzo: Mhedziso uye hukama hwehukama kuti ubude

Nzira 2: Basa Renk.sr

Basa repiri rinoburitsa kushanda kwemasangano muExle Is RAVK.S. Mukupesana nemabasa enzvimbo uye ranc.rv, nemakiromita ehunhu hwezvinhu zvinoverengeka, uyu anoshanda anokona pakati pehukama. Ndokunge, kana maviri maitiro ane kukosha kwakaenzana uye kutevera mushure mekukosha panguva yehuwandu 1, saka vese vari vaviri vachapihwa nhamba 2,5.

Syntax chinzvimbo. Sr yakafanana chaizvo nedhirowa reanoshanda zvekare. Anotaridzika seizvi:

= Rank.sr (nhamba; Reference; [Order])

Iyo formula inogona kuiswa mumannu kana kuburikidza nemabasa tenzi. Mune yekupedzisira vhezheni isu tichamira zvimwe uye tinogara.

1. Isu tinoburitsa kusarudzwa kwesero pane pepa rekubuditsa mhedzisiro. Nenzira imwecheteyo, sezviri munguva yapfuura, enda kumabasa anowoneka kuburikidza ne "kuisa basa" bhatani.
2. Mushure mekuvhura Window Wizard Window Window, isu tinogovera zita re "Statistical" Chikamu "Statistical" zita, uye tinya bhatani re "OK".



3. Hwindo rekupokana rinoitwa. Kupopotedzana kwemushandi uyu kwakafanana neiyo basa rang.rv:
   • Nhamba (kero yefoni ine chinhu chine huwandu hunofanirwa kutsanangurwa);
   • Referensi (kuronga kuronga, chinzvimbo mukati chinoitwa);
   • Kuraira (sarudzo yekusarudzika).

   Kugadzira data mumunda kunoitika nenzira yakafanana neyekupedzisira oparidza. Mushure mekunge zvese zvigadziriso zvakagadzirwa, tinya pane "OK" bhatani.



4. Sezvatinogona kuona, mushure mekupedza zviitiko, mhedzisiro yakaratidzwa muchitokisi yakanyorwa mundima yekutanga yedzidziso iyi. Mhedzisiro yacho pachayo inzvimbo inogara chaiyo kukosha pakati pezvimwe zvakakosha zvehuwandu. Mukupesana nemhedzisiro yacho, Rang.rv, mhedzisiro yeanoshanda chinzvimbo. CER inogona kunge ine kukosha kwechisimba.



5. Sezvazvakamboita formula yapfuura, nekuchinja zvinongedzo kubva kuhukama pamhedziso uye mucherechedzo, huwandu hwese hwe data hunogona kufambiswa ne auto-yakazara. Iyo algorithm yekuita yakafanana chaizvo.

Chidzidzo: Mamwe mabasa ehuwandu muMicrosoft Excel

Chidzidzo: Maitiro ekuita auto-kuzadza muExcel

Sezvauri kuona, pane mabasa maviri muExcel kuti uone iyo nzvimbo yekukoshesa kwakakosha mu data renji: rang.rv uye rank. Zvekare shanduro dzechirongwa, chinzvimbo chehutongi chinoshandiswa, ndechipi chinonyanya kufadza chechiitiko cheRang.rv basa Musiyano mukuru pakati peform Rang.rv uye Rank.sras nderekuti yekutanga yavo inoratidza huwandu hwepamusoro nekwavo kukosha, uye yechipiri inoratidza avhareji muchimiro chechikamu chechikamu. Uyu ndiwo chete mutsauko pakati pevashandi ava, asi inofanira kuenderana kana ichisarudza iyo inoshanda iyo inoshanda mushandisi ari nani kuishandisa.