Lapho usebenza nedatha, kuvame ukuba nesidingo sokuthola ukuthi iyiphi indawo noma enye inkomba ehlala kulolu hlu oluhlanganisiwe ngokuya ngosayizi. Izibalo, lokhu kubizwa ngokuthi simo. I-Excel inamathuluzi avumela abasebenzisi ukuthi benze le nqubo ngokushesha nangokulula. Ake sibheke ukuthi sizisebenzisa kanjani.
Imisebenzi yokubeka
Ukuze wenze isikhundla ku-Excel kukhona imisebenzi ekhethekile. Kumahumusho amadala wohlelo, kwakukhona opharetha oyedwa enzelwe ukuxazulula le nkinga - RANK. Ngezinhloso zokuhambisana, kushiyelwa esigabeni esingafani samafomula nasezinhlelweni zesimanje zohlelo, kodwa kuselulekwa ukusebenza nabalingani abasha kuzo, uma kungenzeka. Lokhu kufaka phakathi opharetha bezibalo. I-RANK.RV futhi I-RANK.SR. Sizokhuluma ngomehluko ne-algorithm yokusebenza nabo ngokuhamba kwesikhathi.
Indlela yoku-1: Umsebenzi weRANK.RV
Umsebenzi I-RANK.RV yenza ukucubungula kwedatha nokubonisa kuseli elicacisiwe inombolo ye-serial yengxabano ebekiwe kusuka kuhlu lokuhlanganisa. Uma amanani athile aneleveli efanayo, lapho-ke opharetha ekhombisa ephezulu kakhulu kusuka kuhlu lwamanani. Uma, ngokwesibonelo, amanani amabili enani elifanayo, khona-ke womabili azonikezwa inombolo yesibili, futhi inani elilandelayo elikhulu lizoba nelesine. Ngendlela, opharetha wenza okufanayo RANK kuzinguqulo ezindala ze-Excel, ngakho-ke le misebenzi ingabhekwa njengefana.
I-syntax yalesi sitatimende ibhalwe kanjena:
= RANK.RV (inombolo; ireferensi; [oda])
Izimpikiswano "inombolo" futhi isixhumanisi nazo ziyadingeka "oda" - ongakukhetha. Njengokuphikisana "inombolo" udinga ukufaka isixhumanisi esitokisini esiqukethe inani, inombolo ye-serial okudingayo ukuthola. Ukuxabana isixhumanisi iqukethe ikheli lalo lonke uhla olubaliwe. Ukuxabana "oda" ingaba nezincazelo ezimbili - "0" futhi "1". Esimweni sokuqala, i-oda libalwa ngokulandelana kokunciphisa, kanti okwesibili, ngokulandelana kokukhuphuka. Uma le ngxabano ingacaciswanga, khona-ke ibhekwa ngokuzenzakalelayo ngohlelo njenge-zero.
Le fomula ingabhalwa ngesandla esitokisini lapho ufuna khona umphumela wokuboniswa ukuthi uboniswe, kepha kubasebenzisi abaningi kulula kakhulu ukusetha okokufaka ngewindi Umsebenzi Wizards.
- Sikhetha eshidi iseli lapho umphumela wokulungiswa kwedatha uzokhonjiswa khona. Chofoza inkinobho "Faka umsebenzi". Yenzelwe endaweni ngakwesobunxele sebha yefomula.
- Lezi zenzo zidala ukuthi iwindi liqale. Umsebenzi Wizards. Inikeza bonke (ngaphandle kokungajwayelekile) abasebenzisi ongabasebenzisa ukwenza amafomula ku-Excel. Esigabeni "Izibalo" noma "Uhlu oluphelele lwe-alfabhethi" thola igama "RANK.RV", ikhethe bese uchofoza inkinobho "Kulungile".
- Ngemuva kwezenzo ezingenhla, iwindi lokuphikisana komsebenzi lizosebenza. Ensimini "Inombolo" faka ikheli leseli lapho idatha ofuna ukubeka khona. Lokhu kungenziwa ngesandla, kepha kulula kakhulu ukukwenza ngendlela okuzoxoxwa ngayo ngezansi. Setha isikhombisi esigangeni "Inombolo", bese ukhetha iseli elifunayo ekhasini.
Ngemuva kwalokho kuzongena ikheli lakhe enkundleni. Ngendlela efanayo sifaka idatha enkambu Xhumanisa, kuphela kuleli cala lapho sikhetha lonke uhla okwenzeka kulo isikhundla.
Uma ufuna isikhundla senzeke kusuka kwesincane kunazo zonke kuya kwesikhulu kunazo zonke, bese kuthi endle "I-oda" isithombe kufanele sisethwe "1". Uma ufuna i-oda lisatshalaliswe lisuka kokukhulu liye kokuncane (futhi ngobuningi bamacala yilokhu kanye okudingekayo), bese ushiya le nkambu ingenalutho.
Ngemuva kokuthi yonke imininingwane engenhla ifakiwe, chofoza inkinobho "Kulungile".
- Ngemuva kokuqeda lezi zinyathelo esitokisini esichaziwe ngaphambilini, kuzovezwa inombolo ye-serial enenani olikhethile phakathi kwalo lonke uhlu lwedatha.
Uma ufuna ukukala indawo yonke ebekiwe, awudingi ukufaka ifomula ehlukile yenkomba ngayinye. Okokuqala, yenza ikheli elisensimini Xhumanisa ngokuphelele. Ngaphambi kwenani ngalinye lokuhlanganisa, engeza uphawu lwedola ($). Ngaso leso sikhathi, shintsha amanani asensimini "Inombolo" ngokuphelele akufanele kube njalo, ngaphandle kwalokho ifomula ngeke ibalwe kahle.
Ngemuva kwalokho, udinga ukubeka isikhombisi ekhoneni elingezansi kweseli, bese ulindela ukuthi umaka wokugcwalisa avele ngendlela yesiphambano esincane. Ngemuva kwalokho bamba phansi inkinobho yegundane kwesobunxele bese uhudula umaki ngokufana nendawo ebaliwe.
Njengoba ukwazi ukubona, ngale ndlela ifomula ikopishwa, futhi simo sizokwenziwa kulo lonke uhla lwedatha.
Isifundo: Umsebenzi Wizard e-Excel
Isifundo: Izixhumanisi ezingaphelele nezihlobene ku-Excel
Indlela 2: umsebenzi weRANK.S.R.
Umsebenzi wesibili owenza ukusebenza kwe-Excel simo I-RANK.SR. Ngokungafani nemisebenzi RANK futhi I-RANK.RV, uma amanani wezinto ezimbalwa ahlangana, lo opharetha unikeza isilinganiso. Okusho ukuthi, uma amanani amabili enani elilinganayo futhi elandela inani elingaphansi kwenombolo 1, khona-ke womabili anikezwe inombolo 2,5.
I-Syntax I-RANK.SR kufana kakhulu nomdwebo wesitatimende esedlule. Kubukeka kanjena:
= RANK.SR (inombolo; ireferensi; [i-oda])
Ifomula ingafakwa ngesandla noma ngeWizadi Yomsebenzi. Sizohlala ekukhetheni okulandelayo ngemininingwane eminingi.
- Sikhetha iseli eshidini ukubonisa umphumela. Ngendlela efanayo nesikhathi esedlule, iya ku Isici Wizard ngokusebenzisa inkinobho "Faka umsebenzi".
- Ngemuva kokuvula iwindi Umsebenzi Wizards khetha izigaba ohlwini "Izibalo" igama I-RANK.SR bese uchofoza inkinobho "Kulungile".
- Iwindi lokuphikisana liyasebenza. Izimpikiswano zalo opharetha ziyafana nomsebenzi I-RANK.RV:
- Inombolo (ikheli leseli eliqukethe into isigaba sayo okufanele inqunywe);
- Xhumanisa (ukuxhumanisa kobubanzi, isikhundla phakathi kwawo okwenziwayo);
- Ukuhleleka (ukuphikisana ngokuzikhethela).
Ukufaka idatha emasimini kwenzeka ngendlela efanayo ne-opharetha wangaphambilini. Ngemuva kokuthi wonke amasethingi aqediwe, chofoza inkinobho "Kulungile".
- Njengoba ubona, ngemuva kwezinyathelo ezithathiwe, umphumela wokubala waboniswa esitokisini esimakwe esigabeni sokuqala salo myalelo. Umphumela uqobo uyindawo ethatha inani elithile phakathi kwamanye amanani ebanga. Ngokungafani nomphumela I-RANK.RVisifinyezo se-opharetha I-RANK.SR ingaba nencazelo ehlelekile.
- Njengasesimweni sefomula yangaphambilini, ngokushintsha izixhumanisi kusuka kusihlobo kuye ngokuphelele futhi kugqanyiswa amamaki, ngokusebenzisa ukuqeda ngokuzenzakalela ungabeka lonke uhlu lwedatha. I-algorithm yezenzo ziyefana.
Isifundo: Eminye imisebenzi yezibalo kuMicrosoft Excel
Isifundo: Ungayenza kanjani i-autocomplete ku-Excel
Njengoba ukwazi ukubona, ku-Excel kunemisebenzi emibili yokunquma simo senani elithile ebangeni ledatha: I-RANK.RV futhi I-RANK.SR. Kumahumusho amadala wohlelo, kusetshenziswa opharetha. RANK, okuyiqiniso, okuyi-analogue ephelele yomsebenzi I-RANK.RV. Umehluko omkhulu phakathi kwamafomula I-RANK.RV futhi I-RANK.SR liqukethe ukuthi eyokuqala yazo ikhombisa inani eliphakeme kakhulu lapho amanani ahlangana, bese elesibili libonisa inkomba ejwayelekile ngendlela yengxenyenamba yedesimali. Lokhu kungumehluko kuphela phakathi kwalaba basebenzisi, kepha kufanele kucatshangwe lapho ukhetha ukuthi yimuphi umsebenzisi okufanele awusebenzise.
