01 ka 01
Hlela Izinombolo Nge-Inani Lamanani ku-Excel
Umsebenzi we-RANK ulinganisa ubukhulu benani uma kuqhathaniswa nezinye izinombolo ohlwini oluthile idatha. Isikhundla asinasondelene nesimo senombolo ohlwini.
Isibonelo, esithombeni ngenhla, ngochungechunge lwamagugu
1, 6, 5, 8, 10
emigqeni emibili nantathu, inombolo 5 inezinga le:
- 4 - njengenombolo yesine ngobukhulu ohlwini - irowu ezimbili;
- 2 - njengenombolo yesibili encane ohlwini - umugqa amathathu
Ayikho indawo efana nendawo yayo njengenani lesithathu kusukela ekugcineni.
Izinga lezinombolo lizofanisa isikhundla salo ohlwini uma uhlu luhlungwa ukuze luhambisane ne-order of ranking.
I-syntax ye-RANK yomsebenzi kanye neziphakamiso
I - syntax yomsebenzi ibhekisela kokuhlelwa komsebenzi futhi ihlanganisa igama lomsebenzi, amabakaki, ukwahlukanisa kwama-comma, nokuphikisana .
I- syntax yomsebenzi we-RANK yile:
= I-RANK (Inombolo, Ref, i-oda)
Inombolo - inombolo okufanele ibalwe. Lokhu kungaba:
- inombolo yangempela - irowu ezine ngenhla;
- ireferensi yeseli endaweni yedatha - imigqa emibili nantathu.
I-Ref - i-array noma ububanzi bezingqikithi zeseli ezikhomba uhlu lwezinombolo ozisebenzisayo ekusezingeni lempikiswano yenombolo .
Uma ama-non-numeric value akhona ebangeni, ayinakwa - irowu emihlanu ngenhla, lapho inombolo engu-5 ibalwa kuqala ngenxa yokuthi inomboro enkulu kunazo zonke izinombolo ohlwini.
I-oda - inani lezinombolo elinquma ukuthi ngabe ukuphikisana kwenombolo kubalwe ekukhuphukeni noma kwehla .
- ukuhleleka - okukhulu kunazo zonke ezincane kunazo zonke: - Uma i- oda i-0 (zero) noma ilahlekile;
- ukukhuphuka (okuncane kunazo zonke kuya kokukhulu) - Uma i- oda yinoma yiliphi inani le-nonzero, njenge-1.
Qaphela : idatha ku- Ref ayidingi ukuthi ihlulwe empeleni ekhuphuka noma yehla ukuze inani le-argument Inani libekwe kulowo myalelo.
Isibonelo somsebenzi we-RANK
Emfanekisweni ngenhla, umsebenzi we-RANK usemaseli B7 kuya ku-E7 futhi ubonisa isimo senombolo 5 ngokuphathelene nezinye izinombolo kukholomu ngayinye.
Ukufaka umsebenzi we-RANK
Kusukela ku-Excel 2010, umsebenzi we-RANK awukwazi ukungena ngokusebenzisa ibhokisi lengxoxo yomsebenzi, njengeminye imisebenzi eminingi ohlelweni.
Ukufaka umsebenzi kufanele kufakwe ngesandla - njengokuthi
= RANK (C2, A2: E2,0)
ungene esitokisini F2 sephepha lokusebenzela.
Ukuhumusha Imiphumela
I- Arguments Number 5 emigqeni amabili kuya kweyisikhombisa inezikhundla ezilandelayo:
- Umzila 2 : wesine - ngoba yinombolo yesine enkulu kunazo zonke uma uhla lwe- ref lubekwe ohlwini lokuhlehla;
- Umzila wesi-3 : owesibili - ngoba inombolo yesibili encane uma uhla lwe- ref lubekwe ohlwini lokunyuka;
- Umzila 4 : wesine - ngoba inombolo yesine enkulu kakhulu uma uhla lwe- ref lubekwe ohlwini lokuhlehla;
- Umzila 5 : okokuqala - ngoba inkulu yezinombolo ezimbili lapho uhla lwe- ref lubekwe ohlwini lokuhlehla;
- Umzila 6 : # N / A - ngoba inombolo engu-5 ayitholakali u-A6 kuya ku-E6.
Izinombolo zezinombolo eziphindaphindiwe
Uma uhlu luqukethe izinombolo eziphindwe kabili umsebenzi ubapha kokubili isikhundla esifanayo. Izinombolo ezilandelayo ohlwini zibalwa ngaphansi.
Isibonelo, irowu lesine linezinombolo ezingu-5 eziphindwe kabili, zombili zibekwe eceleni kwesithathu, kanti inombolo eyodwa ibalwa kwesihlanu - ayikho inani lesine elibekiwe.
Hlela Umsebenzi kusukela ku-Excel 2010
Ku-Excel 2010, umsebenzi we-RANK uthathelwe indawo yi:
I-RANK.AVG - Ibuyisela isikhundla senombolo ohlwini lwezinombolo: usayizi wayo ngokuhambisana namanye amanani ohlwini; uma okungaphezulu kweyodwa kunenani elilinganayo, izinga elijwayelekile libuyiselwe.
RANK.EQ - Ibuyisela isikhundla senombolo kuhlu lwamanani. Ubukhulu bayo buhlobene namanye amanani ohlwini; uma okungaphezulu kweyodwa kunenani elifanayo, isikhundla esiphezulu saleso setethi samagugu siphindiswa.