01 ngo 01
Uhlu lweNombolo ngexabiso leNombolo kwi-Excel
Umsebenzi we-RANK ulinganisa ubungakanani benani ngokuthelekiswa namanye amanani kwiluhlu lwedatha. Isikhundla asinxulumene nesimo senani kuluhlu.
Ngokomzekelo, kumfanekiso ongentla, uluhlu lwamanani
1, 6, 5, 8, 10
kwimigangatho emibini neyesithathu, inani le-5 linomgangatho we:
- 4 - njengowesine inani elikhulu kwinani lomqolo;
- 2 - njengowesibini encinci kwinani elinesibini
Akukho ndawo ifanelana nesimo salo njengexabiso lesithathu ukusuka ekupheleni.
Isikhundla seenombolo siya kufana nesimo sayo kwoluhlu ukuba uludwe luhlelwa ukulandelana nomyalelo wokubeka.
I-Syntax yeeRANK kunye neArguments
I - syntax yomsebenzi ibhekisela kwisakhiwo somsebenzi kwaye ibandakanya igama lomsebenzi, iibakaki, abahluli be-comma kunye neengxabano .
I- syntax yomsebenzi we-RANK yile:
= RANK (Inani, Ref, i-Order)
Inani - inani eliza kubalwa. Oku kunoku:
- inani langempela-umqolo amane ngasentla;
- ireferensi yeseli kwindawo yendawo yedatha - imigangatho yesibini neyesithathu.
I-Ref - uluhlu okanye uluhlu lweeferensi zeeseli ezibhekiselele kuluhlu lwamanani ozobaluleka ekusebenziseni ingxabano yeNombolo .
Ukuba amaxabiso angenani manani akhoyo kwibala, ayinakunyuswa - umqolo wesihlanu apha ngasentla, apho inani le-5 libala kuqala ngoba likhulu kunamanani amabini eluhlu.
Umyalelo - ixabiso leenombolo elinquma ukuba ngaba ingxabano yeNombolo ibalulwe kunyuka okanye yehla .
- ukuhla kwenani - inkulu ukuya kuncinci: - Ukuba umyalelo we-0 (zero) okanye ungashiywanga;
- ukwenyuka umyalelo (encinci ukuya kunkulu) - Ukuba iMyalelo kukho nayiphi na inzuzo ye-nonzero, efana ne-1.
Qaphela : idatha kwi- Ref ayidingi ukuba ihlelwe ngokunyuka okanye ihlawule ukuba inani lempikiswano yenani liza kubalwa kuloo myalelo.
RANK Function Example
Kulo mfanekiso ngasentla, umsebenzi we-RANK ukhona kwiiseli B7 ukuya ku-E7 kwaye ubonisa ukuba usezingeni lenombolo yesi-5 ngokumalunga namanye amanani kwikholamu nganye.
Ukufaka umsebenzi weRANK
Ukususela kwi-Excel 2010, umsebenzi we-RANK awukwazi ukungena ngokusebenzisa ibhokisi yencoko yencoko yomsebenzi, njengeminye imisebenzi emininzi kwinkqubo.
Ukufaka umsebenzi kufuneka kufakwe ngesandla - njengaye
= RANK (C2, A2: E2,0)
kwisisele F2 kwiphepha lokusebenzela.
Ukutolika iziphumo
Inombolo yesiqingatha sesi-5 kwimigangatho yesibini ukuya kwezixhenxe inokubekwa kwezi zilandelayo:
- Umzila wesi-2 : wesine - kuba likhulu lesine inani xa uhla lwe- Ref lubekwe phantsi kwehla;
- Umgca 3 : wesibini - kuba inombolo yesibini encinci xa uhla lwe- Ref lubekwe kwi-ascending order;
- Umzila 4 : wesine - kuba likhulu lesibini kwinani xa uhla lwe- Ref lubekwe phantsi kwehla;
- Row 5 : yokuqala - kuba inkulu yamanani amabini xa uhla lwe- Ref lubekwe phantsi kwehla;
- Umzila 6 : # N / A - kuba inani 5 alikho kwi-A6 ukuya ku-E6.
Usetyenziso lweeNombolo zokuPhinda
Ukuba uluhlu luqulethe iinombolo eziphindwe kabini umsebenzi uzinike isigaba esifanayo. Amanqaku alandelayo kwoluhlu athatyathwa ngaphantsi ngenxa yoko.
Umzekelo, umqolo wesine uqukethe inombolo yesi-5 yee-duplicate, zombini zibekwe kwindawo yesithathu, ngelixa inani elithile libekwe kwisiqingatha sesihlanu - akukho nxalenye yesine ixabiso.
IsiGaba soMsebenzi ukususela kwi-Excel 2010
Ku-Excel 2010, umsebenzi we-RANK watshintshwa ngu:
I-RANK.AVG - Ibuyisela ireyithi yenani kuluhlu lwamanani: ubungakanani bayo ngokumalunga namanye amanani kwiluhlu; ukuba ngaphezulu kwexabiso elinye linesimo esifanayo, ubukhulu bendawo bubuyiselwa.
I-RANK.EQ - Ibuyisela ireyithi yenani kuluhlu lwamanani. Ubukhulu bayo bunxulumene namanye amanani kwiluhlu; ukuba ngaphezulu kwexabiso elilodwa linesimo esifanayo, isigaba esiphambili sale setethi yexabiso libuyiselwa.