LET function

Syntax

Square brackets indicate optional arguments.

Arguments

Practice a complete task

• 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.

• Sum repeated payments for each invoice →

  Combine split receipts and refunds before calculating each invoice balance; keep unmatched receipts visible in the source.

• 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.

• Build a carrier by parcel shipping quote matrix →

  Generate every selected carrier/weight combination using included weight and half-kilogram billing increments.

• 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.

• Compare independent groups without pooling their variances →

  Keep unequal group sizes and sample variances separate, retain fractional Welch degrees of freedom and report a two-sided comparison.

• Cross a column with a horizontal array →

  Use one formula to expand three source amounts across four multipliers while keeping row and column meaning.

• Audit row-wise Boolean masks and counts →

  Convert real Booleans to 0/1, combine row conditions with AND and OR, and reconcile counts without double-counting overlaps.

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.