FILTER function

Syntax

Square brackets indicate optional arguments.

Arguments

Practice a complete task

• Count distinct values and show the list →

  See which customer names are distinct, exclude blank rows, and count the resulting list.

• Build a filtered priority queue with a stable tie rule →

  Select one team at or above a points threshold, then sort the complete records by points descending and numeric ticket ascending.

• Extract both sides of the final separator →

  Use the last literal separator to separate a record prefix from its final field without losing earlier separators or repeated records.

• Normalize and review structured reference codes →

  Create a three-column audit that validates a declared ASCII code shape before extracting a four-character suffix.

• List required IDs missing from another export →

  Build an ordered set difference with exact matches, normalized letter case and one output per missing identifier.

• Reconcile grouped totals from two exports →

  Keep the union of both ID lists, combine signed repeated rows on each side, then report both totals and their difference.

• Combine exports with different column orders →

  Align ID, Team and Units before stacking two exports, preserving duplicate records and signed quantities.

• Flatten numeric readings in a declared scan order →

  Turn a 4 by 3 readings grid into one column while keeping numeric zeroes and excluding text notes and booleans.

• Return the last N active records →

  Skip empty-ID slots, reorder the fields and take the final requested records without sorting or reversing them.

• Compare changes in the same matched records →

  Preserve record alignment, summarize after-minus-before differences and reconcile a two-sided paired test with a change interval.

Reference and compatibility

• Microsoft function documentation ↗

Univer 1.0.4 / Apache-2.0. Calculation checks cover the supplied examples only. The browser worksheet does not implement every Excel feature, external service or connected data type.