Lokacin aiki tare da bayanai, sau da yawa akwai buƙatar gano abin da wuri ɗaya ko wata alama ta mamaye cikin jeri a cikin sharuddan girman. A cikin kididdigar, ana kiran wannan ranking. Excel yana da kayan aikin da ke ba masu amfani damar aiwatar da wannan hanyar cikin sauri da sauƙi. Bari mu gano yadda ake amfani da su.
Ayyukan Ranking
Don aiwatar da ranking a Excel akwai ayyuka na musamman. A cikin tsoffin juzurorin aikace-aikacen, akwai ma'aikaci ɗaya da aka tsara don magance wannan matsalar - RANKA. Don dalilai masu jituwa, an bar shi a wani yanki na daban na dabaru da kuma nau'ikan shirye-shirye na zamani, amma har yanzu yana da kyau a yi aiki da sabbin takwarorinsu a cikinsu, in ya yiwu. Waɗannan sun haɗa da masu aikin ƙididdiga. RANK.RV da RANK.SR. Za muyi magana game da bambance-bambance da algorithm don aiki tare dasu daga baya.
Hanyar 1: aikin RANK.RV
Mai aiki RANK.RV yana aiwatar da bayanan da kuma nunawa a cikin ƙayyadadden tantanin halitta adadin lambar da aka ƙayyade daga jerin jumla. Idan dabi'u da yawa suna da matakin iri ɗaya, to sai mai aikin ya nuna mafi girman daga jerin ƙimomin. Idan, alal misali, dabi'u guda biyu suna da darajar guda ɗaya, to za a sanya su biyun lamba ta biyu, kuma ƙimar mafi girma na gaba tana da ta huɗu. Af, mai aiki yakan yi daidai RANKA A tsoffin juzu'i na Excel, don haka ana iya ɗaukar waɗannan ayyukan daidai.
An rubuta bayanin wannan bayanin kamar haka:
= RANK.RV (lamba; tunani; [tsari])
Muhawara "lamba" da hanyar haɗi ana buƙatar su "oda" - ba na tilas ba ne. A matsayin hujja "lamba" kuna buƙatar shigar da hanyar haɗi zuwa tantanin da ke ɗauke da darajar, lambar serial wacce kuke buƙatar gano. Hujja hanyar haɗi ya ƙunshi adireshin duk kewayon da ake samarwa. Hujja "oda" na iya samun ma'ana biyu - "0" da "1". A farkon lamari, tsari yana kirgawa ta hanyar ragewa, kuma a karo na biyu, cikin hawan tsari. Idan ba a ƙayyade wannan hujja ba, to shirin yana ɗaukar ta kai tsaye ba komai bane.
Ana iya rubuta wannan dabara da hannu a cikin tantanin da kake son nuna sakamakon aiki, amma ga yawancin masu amfani da shi ya fi dacewa a saita shigarwar ta taga. Wizards na Aiki.
- Muna zaɓar akan takarda a cikin sel wanda sakamakon binciken aiki zai nuna. Latsa maballin "Saka aikin". An karkatar da shi zuwa hagu na dabarar dabara.
- Wadannan ayyuka suna sa taga ya fara aiki. Wizards na Aiki. Yana gabatar da duka (tare da banbancin da ba a kera ba) masu aiki waɗanda zaku iya amfani da su don ƙirƙirar dabaru a Excel. A cikin rukuni "Na lissafi" ko "Cikakken jerin haruffa" nemo suna "RANK.RV", zaɓi shi kuma danna maɓallin "Ok".
- Bayan ayyukan da ke sama, za a kunna taga muhawara na ayyuka. A fagen "Lambar" shigar da adireshin tantanin halitta wanda bayanan da kake son sanyawa. Ana iya yin wannan da hannu, amma ya fi dacewa a yi shi ta hanyar da za a tattauna a ƙasa. Sanya siginan kwamfuta a cikin filin "Lambar", sannan sai kawai zaɓi zaren da ake so a takardar.
Bayan haka, adireshin ta zai shiga a filin. Haka muke shigar da bayanai a fagen Haɗi, kawai a wannan yanayin zamu zaɓi kewayon duka tsakanin abin da ranking yake faruwa.
Idan kana son martaba ta faru daga ƙarami zuwa babba, to a cikin filin "Oda" adadi ya kamata a saita "1". Idan kana son a rarraba umarnin daga babba zuwa karami (kuma a mafi yawan lokuta wannan shine ainihin abin da ake buƙata), to sai ka bar wannan filin fanko.
Bayan an shigar da duk bayanan da ke sama, danna maɓallin "Ok".
- Bayan kammala waɗannan matakan a cikin tantanin da aka ƙayyade a baya, za a nuna lambar serial wanda ke da ƙimar da kuka zaɓa tsakanin duk bayanan bayanan.
Idan kuna son sanya duk yankin da aka ƙayyade, to, baku buƙatar shigar da tsari daban don kowane mai nuna alama. Da farko dai, yi adireshin a filin Haɗi cikakken. Kafin kowane darajar daidaitawa, ƙara alamar dala ($). A lokaci guda, canza dabi'u a fagen "Lambar" cikakke bai kamata ya kasance ba, in ba haka ba za'a kirkiri tsari daidai.
Bayan haka, kuna buƙatar sanya siginan kwamfuta a cikin ƙananan kusurwar dama na tantanin, kuma jira alamar mai cika ya bayyana a cikin karamin gicciye. Sai ka riƙe maɓallin linzamin kwamfuta na hagu ka ja alamar a layi daya a yankin da aka lissafa.
Kamar yadda kake gani, ta wannan hanyar an kwafa fom ɗin, kuma za a yi ranking ɗin a kan duk kewayon bayanan.
Darasi: Wizard ɗin Aiki a cikin Excel
Darasi: Cikakkar kuma haɗin dangi a cikin Excel
Hanyar 2: RANK.S.R. aiki
Aiki na biyu wanda yake aiwatar da aikin ranking shine RANK.SR. Ba kamar ayyuka ba RANKA da RANK.RV, idan dabi'un abubuwan da yawa ya zo daidai, wannan ma'aikaci yana bada matsakaiciyar matakin. Wato, idan dabi'u biyu daidai suke da daidai kuma suka bi darajar ƙarƙashin lamba 1, to, za a sanya su biyun lambar 2.
Syntax RANK.SR yayi kama da zane na sanarwa da ta gabata. Ya yi kama da wannan:
= RANK.SR (lamba; tunani; [tsari])
Za'a iya shigar da dabara don amfani da hannu ko ta amfani da Wizard ɗin Aiki. Zamuyi cikakken bayani game da abinda ya gabata.
- Muna zaɓar kwayar akan takarda don nuna sakamakon. Haka kuma kamar lokacin da ya gabata, jeka Mayan fasalin ta maballin "Saka aikin".
- Bayan bude taga Wizards na Aiki zaɓi rukuni a cikin jerin "Na lissafi" suna RANK.SR kuma danna maballin "Ok".
- Ana kunna taga gardamar. Hujjojin wannan ma'aikaci daidai suke da na aikin RANK.RV:
- Lambar (adireshin tantanin halitta wanda ya ƙunshi kashi wanda matakansa ya kamata a ƙaddara);
- Haɗi (daidaitawa daga cikin kewayon, ranking a cikin wanda aka yi);
- Oda (hujja ba na tilas ba).
Shiga bayanai a cikin filayen yana faruwa daidai kamar yadda yake tare da wanda ya gabata. Bayan an gama dukkan saitunan, danna maballin "Ok".
- Kamar yadda kake gani, bayan matakan da aka ɗauka, an nuna sakamakon ƙididdigewa a cikin tantanin da aka yiwa alama a sakin farko na wannan umarnin. Sakamakon da kanta wuri ne wanda ke da ƙimar takamaiman a tsakanin sauran ƙimomin kewayon. Ya bambanta da sakamakon RANK.RVtaƙaitawar mai aiki RANK.SR na iya samun ma'ana.
- Kamar yadda yake game da dabarar da ta gabata, ta hanyar canza hanyoyin haɗin daga dangi zuwa maƙasudin haske da alamomin alama, ta amfani da autocomplete zaku iya sanya jerin bayanan duka. Algorithm na ayyuka daidai yake.
Darasi: Sauran ayyukan ƙididdiga a Microsoft Excel
Darasi: Yadda ake yin autocomplete a Excel
Kamar yadda kake gani, a cikin Excel akwai ayyuka guda biyu don ƙididdige darajar ƙimar wata darajar a cikin kewayon bayanai: RANK.RV da RANK.SR. Don tsofaffin nau'ikan shirin, ana amfani da mai aiki. RANKA, wanda, a zahiri, cikakken misaltawa ne na aikin RANK.RV. Babban bambanci tsakanin dabaru RANK.RV da RANK.SR ya ƙunshi gaskiyar cewa farkon su yana nuna babban matakin lokacin da dabi'u suka zo daidai, na biyu kuma yana nuna matsakaicin mai nuna alama a cikin hanyar sulusi na ƙira. Wannan shine kawai bambanci tsakanin waɗannan masu aikin, amma dole ne a la'akari dashi lokacin zaɓar aikin da mai amfani yakamata yayi amfani dashi.
