Jifunze Excel RANK() kwa Ascending: Pata Nafasi ya Ndogo Kwanza

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