Jifunze jinsi ya kutumia SORT() kwenye Excel kupanga data kiotomatiki kwa ascending au descending order. Tazama tutorials zaidi, pakua mifumo ya Excel bure, na pata msaada wa WhatsApp.”
1. SORT() Function
SORT() inarudisha data iliyopangwa kutoka kwenye range uliyoingiza. Ni muhimu kwa reporting, dashboards, na automation.
Syntax:
SORT(array, [sort_index], [sort_order], [by_col])
array = range ya data unayotaka kupanga
sort_index (optional) = column au row unayotaka kutumia kama reference ya sorting (default = 1)
sort_order (optional) = 1 kwa ascending, -1 kwa descending (default = 1)
by_col (optional) = TRUE ili kupanga kwa columns, FALSE au blank kwa rows
2. Mfano Rahisi
Mfano 1: Pangilia data kwa ascending order
A
Orange
Apple
Mango
Formula:
=SORT(A2:A4)
Result:
Apple
Mango
Orange
Hapa, SORT() inapanga alphabetical order kiotomatiki.
3. Pangilia kwa Descending Order
Mfano 2:
=SORT(A2:A4, 1, -1)
Result:
Orange
Mango
Apple
sort_order = -1 inapanga data kutoka kubwa kwenda ndogo (descending)
4. SORT() Pamoja na SORTBY()
Unaweza kutumia SORT() pamoja na SORTBY() kuunda complex sorting.
Mfano: Pangilia items kulingana na price
Item Price
Pen 2
Book 5
Pencil 1
Formula:
=SORT(A2:B4, 2, 1)
Hii inapanga data kulingana na column ya 2 (Price) kwa ascending order
Result: Pencil, Pen, Book
5. SORT() Pamoja na FILTER() na UNIQUE()
Unaweza kupanga data iliyochujwa na unique values.
Mfano:
=SORT(UNIQUE(FILTER(A2:A10, B2:B10="Available")))
Hii inatoa list ya unique items tu ambazo ziko "Available" na kisha inapanga alphabetical order.
6. Tips Muhimu
SORT() ni muhimu sana kwa automation ya dashboards na reporting.
Inaweza kuunganishwa na formulas nyingine kama FILTER(), UNIQUE(), INDEX(), MATCH() kwa dynamic tables.
Inarahisisha kuunda lists zilizo organized, reports safi, na dynamic 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