Jifunze Excel SMALL(): Pata Nambari Ndogo Zaidi Kwenye List

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

1. SMALL() Function

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

Syntax:

SMALL(array, k)


array = range ya numbers

k = nafasi ya nambari ndogo unayotaka (1 = smallest, 2 = second smallest, etc.)

2. Mfano Rahisi

Mfano 1: Pata nambari ndogo zaidi

A
50
80
30

Formula:

=SMALL(A2:A4,1)


Result:
30

k = 1 inatoa number ndogo zaidi.

3. Pata Nambari ya Pili au Nyingine

Mfano 2: Pata nambari ya pili ndogo zaidi

=SMALL(A2:A4,2)


Result:
50

k = 2 inatoa number ya pili ndogo zaidi.

4. SMALL() Pamoja na FILTER()

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

Mfano: Pata 3 scores ndogo zaidi kutoka list ya waliopass:

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


FILTER() inachuja data kulingana na criteria

SMALL() inapata lowest n values

5. SMALL() Pamoja na SEQUENCE()

Unaweza kuunda list ya n smallest values dynamically:

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


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

SMALL() inarudisha lowest 3 values kwa array

Hii inarahisisha kuunda dynamic bottom n list

6. Tips Muhimu

SMALL() ni muhimu sana kwa ranking, bottom n analysis, na reporting.

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

Inarahisisha automated bottom scores, sales analysis, 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