01 na 01
Lissafin Lissafi ta Ƙimar Lamba a Excel
Ayyukan RANK yana darajar girman adadi idan aka kwatanta da wasu lambobi a lissafin bayanai. Matsayi ba shi da dangantaka da matsayi na lambar a cikin jerin.
Alal misali, a cikin hoto a sama, don jerin dabi'u
1, 6, 5, 8, 10
a cikin layuka biyu da uku, lamba 5 yana da tasiri na:
- 4 - a matsayi na huɗu mafi girma a jerin - jere biyu;
- 2 - azaman na biyu mafi ƙanƙanci a cikin jerin - jere uku
Babu matakan da ya dace da matsayinsa a matsayi na uku daga ko wane karshen.
Matsayi na lamba zai dace da matsayinsa cikin jerin idan aka tsara jeri don daidaitawa da tsari na ranking.
Ƙungiyar RANK Function da Arguments
Haɗin aikin aiki yana nufin layout na aikin kuma ya haɗa da sunan aiki, shafuka, rabuɗɗun takaddama, da muhawara .
Haɗin aikin RANK shine:
= RANK (Number, Ref, Order)
Lambar - lambar da za'a zaba. Wannan zai iya zama:
- ainihin lambar - jere hudu a sama;
- tantancewar tantanin halitta zuwa wurin samin bayanai - layuka biyu da uku.
Ra'ayi - jigilarwa ko kewayon tantancewar salula wanda ke nuna jerin lambobi don amfani da su a cikin Girman Magana.
Idan lambobi marasa lambobi sun kasance a cikin kewayo, ana watsi da su - layi biyar a sama, inda aka sanya lambar 5 ta farko domin shi ne mafi yawan lambobi biyu a jerin.
Order - darajar lambobi da ke ƙayyade ko an ƙidayar Magana a cikin hawan ko saukarwa .
- Sakamakon sauka - mafi girma ga mafi ƙanƙanci: - Idan Order yana 0 (zero) ko kuma an cire shi;
- Tsarin girma (mafi ƙanƙanta zuwa mafi girma) - Idan Order yana da duk wani nau'i mai daraja, kamar 1.
Lura : bayanai a cikin Ref bazai buƙaci a zahiri a haɗe a hawan hawa ko saukarwa don darajan ƙimar Maɗaukaki a zaba a cikin wannan tsari.
RANK Function Misali
A cikin hoton da ke sama, aikin RANK yana samuwa a cikin sel B7 zuwa E7 kuma yana nuna darajar domin lambar 5 dangane da sauran lambobi a kowanne shafi.
Shigar da aikin RANK
Tun da Excel 2010, ba za a iya shigar da aikin RANK ba ta amfani da akwatin maganganun , kamar sauran ayyuka a cikin shirin.
Don shigar da aikin dole ne a shigar da hannu - kamar
= RANK (C2, A2: E2,0)
cikin cell F2 na takardar aiki.
Tsarin fassara sakamakon
Lambar Magana 5 a cikin layuka biyu zuwa bakwai yana da marubucin da ke biyowa:
- Row 2 : na huɗu - saboda ita ce lambar mafi girma ta hudu a yayin da aka keɓance tasirin Ref ɗin a cikin tsari mai saukowa;
- Rowi 3 : na biyu - saboda ita ce mafi girma mafi girma a yayin da aka ƙayyade Ƙaƙwalwar ajiya a tsari mai girma;
- Rowin 4 : na huɗu - domin ita ce lambar mafi girma ta hudu a yayin da aka ƙayyade tashar Ref ɗin a cikin tsari mai saukowa;
- Hada na 5 : na farko - saboda ya fi girma lambobi biyu a yayin da aka ƙaddamar da Ƙaƙwalwar ajiya ta hanyar saukowa;
- Rowi 6 : # N / A - domin lambar 5 ba a cikin kewayon A6 zuwa E6 ba.
Ƙididdigar Lissafin Kwafi
Idan jerin sun ƙunshi lambobi biyu su ne aikin ya ba su duka matsayi. Lambobi na gaba a cikin lissafin suna cikin ƙananan asali.
Alal misali, jere na hudu ya ƙunshi lamba mai lamba 5 ta, dukansu suna biye na uku, yayin da lambar ɗaya ta kasance na biyar - babu ɗakunan aji na hudu.
Rank Function tun Excel 2010
A cikin Excel 2010, aikin RANK ya maye gurbin da:
RANK.AVG - Yana dawo da matsayi na lamba a lissafin lambobi: girmansa ya danganta da sauran dabi'u a jerin; idan fiye da ɗaya darajar yana da matsayi ɗaya, an mayar da matsakaicin matsayi.
RANK.EQ - Yana dawo da matsayi na lamba a lissafin lambobi. Girmanta ya danganta da sauran dabi'un cikin jerin; idan fiye da ɗaya darajar yana da matsayi ɗaya, za a mayar da mafi girman matsayi na wannan ma'auni.