Jifunze jinsi ya kutumia RANK() kwenye Excel kwa ascending order kupata nafasi ya number ndogo kwanza kwenye list. Tazama tutorials zaidi, pakua mifumo ya Excel bure, na pata msaada wa WhatsApp.”
1. RANK() Function kwa Ascending
RANK() inarudisha position ya number katika list. Kwa ascending order, number ndogo zaidi inakuwa rank 1.
Syntax:
RANK(number, ref, 1)
number = number unayotaka kupata rank yake
ref = range ya numbers ili kuhesabu ranking
1 (order) = ascending order (smallest = rank 1)
2. Mfano Rahisi
A
50
80
30
Formula:
=RANK(A2, A$2:A$4, 1)
Result:
A2 = 50 → rank 2
A3 = 80 → rank 3
A4 = 30 → rank 1
Hapa, number ndogo zaidi inapata rank 1, kubwa zaidi rank kubwa zaidi.
3. Conditional Ranking kwa Ascending
Unaweza kuunda ranking kwa criteria fulani:
A B
Item Category
Pen Office
Book School
Pencil Office
Eraser School
Formula:
=RANK(A2, IF(B$2:B$5="Office", A$2:A$5), 1)
IF() inachuja data kulingana na category "Office"
1 = ascending order (smallest = rank 1)
Excel 365/2021 inafanya automatically, Excel 2019 na chini lazima Ctrl+Shift+Enter
4. Conditional Ranking kwa Multiple Criteria
Mfano: Rank ya number ndogo kwanza kwa category na status:
A B C
Item Category Status
Pen Office Available
Book School Sold
Pencil Office Available
Eraser School Available
Formula:
=RANK(A2, FILTER(A$2:A$5, (B$2:B$5="Office")*(C$2:C$5="Available")), 1)
FILTER() inachuja data yenye criteria zote
1 = ascending order
5. Tips Muhimu
RANK() kwa ascending ni muhimu kwa bottom analysis, cost-based ranking, na data grading.
Conditional ascending ranking inarahisisha dynamic dashboards na reporting kulingana na criteria.
Kwenye Excel 2019 na chini, tumia IF() + Ctrl+Shift+Enter ili kuunda array formulas.
Links Muhimu
Tazama tutorials zaidi za Excel: https://www.faulink.com
Download mifumo ya Excel bure: https://www.faulink.com/excel_mifumo.php
Msaada wa WhatsApp: https://wa.me/255693118509