DIFF

Removes rows from a range.

Syntax

DIFF(range; diffRange)

  • range - a range of values - Value type: range with numbers as expected values

  • diffRange - a column defining which rows should be removed from range - Value type: column range

    • all rows of range which contain a value which is included in diffRange as well are removed.

Examples