FILTER

Returns only records that meet specified conditions.

Syntax

=FILTER(array,include,[if_empty])

Example

=FILTER(A2:H100,D2:D100=”Sirsa”,”No Data”)

Returns all sales records from Sirsa.

SORT

Sorts an array automatically.

Syntax

=SORT(array,[sort_index],[sort_order],[by_col])

Example

=SORT(A2:H100,8,-1)

Sorts the dataset by the 8th column in descending order.

SORTBY

Sorts one range based on another range.

Syntax

=SORTBY(array,by_array1,[sort_order1],…)

Example

=SORTBY(A2:H100,H2:H100,-1)

Sorts the complete dataset according to Sales, highest first.

Practice

Create:

  1. Sirsa-only sales report
  2. Highest-to-lowest sales report
  3. Product-wise sorted report
PreviousNext