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