01 ya 01
Serengani Numeri ndi Zofunika Zambiri mu Excel
Ntchito ya RANK imakhala kukula kwa nambala poyerekeza ndi manambala ena m'ndandanda deta. Udindo ulibe chiyanjano ndi malo a nambala mundandanda.
Mwachitsanzo, mu chithunzi pamwambapa, chifukwa cha mfundo zabwino
1, 6, 5, 8, 10
m'mizere iwiri ndi itatu, chiwerengero cha 5 chili ndi:
- 4 - monga chiwerengero chachinayi chachikulu pa mndandanda - mzere wachiwiri;
- 2 - monga chiwerengero chachiwiri chochepa mndandanda - mzere wachitatu
Palibe chiwerengero chomwe chikugwirizana ndi malo ake monga mtengo wachitatu kuchokera kumapeto.
Udindo wa chiwerengero udzatsatizana ndi malo ake mndandanda ngati mndandanda umasankhidwa kuti ufanane ndi ndondomeko yoyenera.
Syntax ndi Mpikisano wa Ntchito YANKHALA
Mawu omasulira a ntchito amatanthawuza momwe ntchitoyo ikuyendera ndipo imaphatikizapo dzina la ntchito, mabakiteriya, olekanitsa, ndi zifukwa .
Syntax ya RANK ntchito ndi:
= NANKA (Number, Ref, Order)
Nambala - nambala yoti ikhale yoyenera. Izi zikhoza kukhala:
- nambala yeniyeni - mzere wanayi pamwambapa;
- chiwerengero cha selo kumalo a deta - mizere iwiri ndi itatu.
Lembani - mndandanda wa ma selo omwe amasonyeza mndandanda wa ziwerengero zomwe mungagwiritse ntchito polemba nambala ya nambala .
Ngati palibe chiwerengero cha chiwerengero chomwe chilipo, sichimasamalidwa - mzere wachisanu pamwambapa, pamene nambala 5 ikuyikidwapo yoyamba chifukwa ndi yayikulu kwambiri pa nambala ziwirizo.
Lamulo - chiwerengero cha chiwerengero chomwe chimatsimikizira ngati ndemanga ya Nambala ili payekha pa kukwera kapena kutsika .
- Kutsika - chachikulu mpaka chaching'ono: - Ngati Order ndi 0 (zero) kapena anasiya;
- kukwera dongosolo (yaying'ono mpaka yaikulu) - Ngati Order ndi mtengo wapadera, monga 1.
Zindikirani : deta mu Ref siyeneratu kuti ikonzedwe kukwera kapena kutsika kuti ndondomeko ya chiwerengero cha Nambale ikhale yoyenera mu dongosolo limenelo.
CHIPHUNZITSO CHA NTCHITO
Mu chithunzi pamwambapa, ntchito ya RANK ili m'maselo B7 mpaka E7 ndipo imasonyeza kusankhidwa kwa nambala 5 poyerekeza ndi ziwerengero zina m'mbali iliyonse.
Kulowa ntchito ya RANK
Kuchokera ku Excel 2010, ntchito ya RANK silingalowetsedwe pogwiritsa ntchito bokosi la zokambirana , monga ntchito zambiri pulogalamuyi.
Kulowa ntchitoyi iyenera kuti ikhale yolembedwa - monga
= NTHAWI (C2, A2: E2,0)
kulowa mu selo F2 ya worksheet.
Kutanthauzira Zotsatira
Chiwerengero cha nambala 5 m'mizera 2 mpaka 7 ali ndi zigawo zotsatirazi:
- Mzere 2 : Chachinayi - chifukwa ndi chiwerengero chachinayi chachikulu pamene ref range ikuwerengera mukutsika;
- Row 3 : chachiwiri - chifukwa ndi nambala yaing'ono kwambiri pamene fereji ya Ref ikupezeka pa kukwera;
- Mzere 4 : Chachinayi - chifukwa ndi chiwerengero chachinayi chachikulu pamene ref range ikuwerengedwa mukutsika;
- Row 5 : choyamba - chifukwa ndilo lalikulu la nambala ziwiri pamene fiber ya Ref ikuwerengedwa mukutsika;
- Row 6 : # N / A - chifukwa chiwerengero cha 5 sichipezeka pa A6 mpaka E6.
Zosindikiza Zophatikiza Nambala
Ngati mndandanda uli ndi nambala zowerengeka, ntchitoyo imapereka udindo womwewo. Mndandanda wa ziwerengero zomwe zili m'mndandandawu ndizomwe zili m'munsimu.
Mwachitsanzo, mzere wachinayi uli ndi chiwerengero chachisanu chachiwiri, zonsezi ndizoyikidwa pachitatu, pomwe nambala imodzi ndiyiyi yachisanu - palibe chiwerengero chachinayi chomwe chilipo.
Chiwerengero cha Ntchito kuyambira Excel 2010
Mu Excel 2010, ntchito ya RANK idasinthidwa ndi:
RANK.AVG - Kubwezeretsa chiwerengero cha nambala mndandanda wa ziwerengero: kukula kwake poyerekeza ndi mfundo zina mundandanda; ngati oposa amodzi ali ndi udindo womwewo, ambiri amawongolera.
RANK.EQ - Kubwezeretsa chiwerengero cha nambala mundandanda wa manambala. Kukula kwake kumagwirizana ndi mfundo zina m'ndandanda; ngati oposa amodzi ali ndi udindo womwewo, udindo wapamwamba wa chikhalidwe chimenecho wabwezedwa.