Jifunze jinsi ya kutumia RANK.IF() kwenye Excel kupata nafasi ya number kulingana na condition au criteria fulani. Tazama tutorials zaidi, pakua mifumo ya Excel bure, na pata msaada wa WhatsApp.”

1. RANK.IF() in Excel

Kumbuka: Excel haina function rasmi ya RANK.IF(), lakini unaweza kufanya conditional ranking kwa kutumia RANK() + IF() au RANK() + FILTER().

Syntax ya Conditional Ranking:

=RANK(number, IF(criteria_range=criteria, number_range), order)


number = number unayotaka kupata rank yake

criteria_range = range ya data unayotaka kuchunguza criteria

criteria = condition unayotaka

number_range = range ya numbers unazopanga rank

order = 0 kwa descending (largest = 1), 1 kwa ascending (smallest = 1)

Kumbuka:

Excel 2019 na chini inahitaji Ctrl+Shift+Enter kwa array formula

Excel 365/2021 inafanya automatically

2. Conditional Ranking Mfano Rahisi
A B
Score Class
80 A
90 B
70 A
85 B

Tunataka rank ya scores za Class A tu.

Formula:

=RANK(A2, IF(B$2:B$5="A", A$2:A$5), 0)


IF(B$2:B$5="A", A$2:A$5) → inachuja scores za Class A tu

RANK() inapata position ya score katika filtered list

Result:

80 → rank 2

70 → rank 1

3. Conditional Ranking kwa Excel 365/2021 na FILTER()
=RANK(A2, FILTER(A$2:A$5, B$2:B$5="A"), 0)


FILTER() inachuja scores za Class A

RANK() inarudisha position ya score kwenye filtered list

Result ni sawa na formula ya IF()

4. Conditional Ranking kwa Multiple Criteria
A B C
Score Class Status
80 A Pass
90 B Fail
70 A Pass
85 B Pass

Formula: Rank kwa Class A na Status Pass

=RANK(A2, FILTER(A$2:A$5, (B$2:B$5="A")*(C$2:C$5="Pass")), 0)


(B$2:B$5="A")*(C$2:C$5="Pass") → AND condition

FILTER() inachuja data yenye criteria zote

RANK() inarudisha position ya score katika filtered list

5. Tips Muhimu

Conditional ranking ni muhimu kwa dynamic dashboards, leaderboard, student grading, na sales analysis.

Kwenye Excel 2019 na chini, IF() + Ctrl+Shift+Enter ni lazima

Kwenye Excel 365/2021, FILTER() + RANK() inafanya automatically

Unaweza kuchagua order = 1 kwa ascending au 0 kwa descending

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