Jifunze Excel FILTER(): Chuja Data Kulingana na Criteria

Jifunze jinsi ya kutumia FILTER() kwenye Excel kuchuja data kulingana na criteria fulani. Tazama tutorials zaidi, pakua mifumo ya Excel bure, na pata msaada wa WhatsApp.”

1. FILTER() Function

FILTER() inarudisha subset ya data kutoka kwenye range, kulingana na criteria uliyoingiza. Ni muhimu kwa reporting, data analysis, na automation.

Syntax:

FILTER(array, include, [if_empty])

array = range ya data unayotaka kuchuja

include = condition au criteria unayotaka kutumia

if_empty (optional) = value inayorudishwa ikiwa hakuna data inayokidhi condition

2. Mfano Rahisi

Mfano 1: Chuja data kulingana na condition

A B
Item Status
Pen Available
Book Sold
Pencil Available

Formula:

=FILTER(A2:A4, B2:B4="Available")

Result:
Pen
Pencil

Hapa, FILTER() inachuja items ambazo zina status "Available".

3. FILTER() Pamoja na IF_EMPTY

Unaweza kurudisha message maalum ikiwa hakuna data inayokidhi criteria.

Mfano:

=FILTER(A2:A4, B2:B4="Sold", "Hakuna items zilizopatikana")

Result: Book

Ikiwa hakuna item yenye status "Sold", FILTER() inarudisha "Hakuna items zilizopatikana"

4. FILTER() Pamoja na UNIQUE()

Unaweza kuchuja data kisha kutoa values zisizojirudia kwa kutumia UNIQUE().

Mfano:

=UNIQUE(FILTER(A2:A10, B2:B10="Available"))

Hii inatoa list ya unique items tu ambazo ziko "Available".

5. FILTER() Pamoja na SORT()

FILTER inaweza kuunganishwa na SORT() ili kupata filtered data iliyopangwa.

Mfano:

=SORT(FILTER(A2:A10, B2:B10="Available"))

Hii inachuja data kulingana na condition na kisha inapangia alphabetical order.

6. Tips Muhimu

FILTER() ni nguvu sana kwa dynamic reporting na dashboards.

Inaweza kuunganishwa na formulas nyingine za Excel kama UNIQUE(), SORT(), INDEX(), MATCH().

Inarahisisha automated lists, dynamic tables, na conditional calculations.

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