Jifunze Excel LARGE(): Pata Nambari Kubwa Zaidi Kwenye List

Jifunze jinsi ya kutumia LARGE() kwenye Excel kupata nambari kubwa zaidi katika list au range. Tazama tutorials zaidi, pakua mifumo ya Excel bure, na pata msaada wa WhatsApp.”

1. LARGE() Function

LARGE() inarudisha nth largest value kutoka kwenye range ya numbers uliyoingiza. Ni muhimu kwa data analysis, ranking, na reporting.

Syntax:

LARGE(array, k)

array = range ya numbers

k = nafasi ya nambari kubwa unayotaka (1 = largest, 2 = second largest, etc.)

2. Mfano Rahisi

Mfano 1: Pata nambari kubwa zaidi

A
50
80
30

Formula:

=LARGE(A2:A4,1)

Result:
80

k = 1 inatoa number kubwa zaidi.

3. Pata Nambari ya Pili au Nyingine

Mfano 2: Pata nambari ya pili kubwa zaidi

=LARGE(A2:A4,2)

Result:
50

k = 2 inatoa number ya pili kubwa zaidi.

4. LARGE() Pamoja na SORT() na FILTER()

Unaweza kutumia LARGE() kupata top n values kutoka list iliyochujwa:

Mfano: Top 3 scores kutoka list

=LARGE(FILTER(B2:B10,C2:C10="Passed"),1)
=LARGE(FILTER(B2:B10,C2:C10="Passed"),2)
=LARGE(FILTER(B2:B10,C2:C10="Passed"),3)

FILTER() inachuja data kulingana na criteria

LARGE() inapata top n values

5. LARGE() Pamoja na SEQUENCE()

Unaweza kuunda top n values dynamically:

=LARGE(A2:A10, SEQUENCE(3))

SEQUENCE(3) inatoa array ya {1;2;3}

LARGE() inarudisha top 3 values kwa array

Hii inafanya dynamic top n list bila kuandika formulas nyingi

6. Tips Muhimu

LARGE() ni muhimu sana kwa ranking, top n analysis, na reporting.

Inaweza kuunganishwa na FILTER(), SEQUENCE(), SORT(), UNIQUE() kwa dynamic dashboards.

Inarahisisha automated top scores, sales leaders, na summary reports.

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