01 ye 01
Ratidza Numeri neNhamba Dzakakosha muExpcel
RANK basa rinoenderana nekukura kwechiverengero ichienzaniswa nedzimwe nhamba murondedzero data. Nzvimbo yacho haina hukama nehuwandu hwemunhu pane urongwa.
Semuenzaniso, mumufananidzo uri pamusoro, nokuda kwezvikamu zvehutano
1, 6, 5, 8, 10
mumitsara miviri neyhatu, nhamba ye5 ine nhamba ye:
- 4 - seyo nhamba yechina huru pane urongwa - mutsara maviri;
- 2 - sechipiri chechidiki mutsara-mutsara mitatu
Hapana kuenzaniswa kunofananidzwa nechigaro chayo sechitatu chekukosha kubva kumagumo.
Nhamba yenhamba ichafananidza nharaunda yayo mune urongwa kana urongwa hwakarongedzwa kuti huenzane nehutano hwekunyoresa.
Syntax Yemashandi yeRANK Function uye Arguments
Mutsara webasa unoreva kurongeka kwebasa racho uye rinosanganisira zita rebasa, mabheji, vatengesi vemavara, uye nharo .
Mutsara weRANK basa ndewokuti:
= RANK (Number, Ref, Order)
Nhamba - nhamba inofanira kuverengwa. Izvi zvinogona kuva:
- iyo nhamba chaiyo - mutsara mana pamusoro;
- sero rinoreva nzvimbo ye data - mitsetse mbiri nehatu.
Ref - iyo yakareba kana uwandu hwemaferensi ezvinyorwa zvinotaura kune runyorwa rwemajeri kuti rushandise pakurongedza nhamba yeNhamba .
Kana zvisingaverengeki nhamba zviripo mumuganhu, hazvina hanya - mutsara wechishanu kumusoro, uko nhamba ye5 inotanga kuverengwa nokuti ndiyo huru pane nhamba mbiri dziri murwendo.
Murairo - kukosha kwenhamba iyo inotarisa kuti Nhamba yeNhamba inowanikwa mukukwira kana kuburuka kurongeka.
- kuburuka kurongeka - kukura kusvika kudukuduku: - Kana Mutemo uri 0 (zero) kana usina kusiyiwa;
- kukwira urongwa (duku kudarika chikuru) - Kana Mutemo ichinhu chipi nechipi chezero, yakadai sa1.
Cherechedza : data iri muRef haifaniri kukonzerwa pakukwira kana kuburuka kuronga kuti nhamba yeNhamba inotarisirwa kuve yakarongerwa mumutemo iwoyo.
RANK Function Example
Mumufananidzo uri pamusoro, RANK basa iri mumasero B7 kusvika E7 uye inoratidza kusarudzwa kwe nhamba 5 maererano nedzimwe nhamba muhomwe imwe neimwe.
Kupinda Basa RANK
Sezvo Excel 2010, basa reRANK haigoni kupindira kushandisa sarudzo yebhokisi rebhokisi , semamwe mabasa akawanda purogiramu.
Kuti upinde basa rinofanira kunge rakapinda nemunhu - zvakadai
= RANK (C2, A2: E2,0)
muchikamu cheF2 chebasa rekushanda.
Kududzira Mhinduro
Nhamba nhamba 5 mumiganhu miviri kusvika kune yechinomwe ine zvikwata zvinotevera:
- Row 2 : yechina - nokuti iyo nhamba yechina huru apo Ref range inowanikwa mukuderera;
- Row 3 : yechipiri - nokuti inhamba yechipiri shomanana apo fururu yeR ref inowanikwa mukukwira;
- Row 4 : yechina - nokuti iyo nhamba yechina huru apo Ref fungiro inowanikwa mukudzika kwekuronga;
- Row 5 : kutanga-nokuti yakawanda yehamba nhamba mbiri apo Ref fungiro inowanikwa mukudzika kwekuronga;
- Row 6 : # N / A - nokuti nhamba ye5 haina kuwanika pakureba A6 kusvika E6.
Dzokorora Dhinda Dhamba
Kana rondedzero ine nhamba dzinyorwa basa iro rinovapa zvose zvakafanana. Nhamba dzinotevera nhamba dziri muurongwa dzinoratidzika sechepamusoro semugumisiro.
Semuenzaniso, mutsara wechina unopindirana nhamba ye5, zvose zviri mbiri yechitatu, apo nhamba imwe inonzi yechishanu - hapana chechina chinotaridzika.
Rudzi Rweshoko kubva kuExcel 2010
MuExcel 2010, basa reRANK rakatsiviwa ne:
RANK.AVG - Inodzorera nhamba yenhamba pachirongwa chemashamba: huwandu hwayo maererano nedzimwe tsika mumutauro; kana huwandu hunopfuura humwe hune huwandu hwakaenzana, wegaji yepamusoro yakadzorerwa.
RANK.EQ - Inodzorera nhamba yehamba nhamba yezinhamba. Kukura kwaro kunopindirana nemamwe maitiro ari muurongwa; kana huwandu hunopfuura humwe hune huwandu hwakaenzana, hukuru hwepamusoro hwehuyo hwehutano hunodzorerwa.