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