Using the Excel DELTA Function

Summary
The Excel DELTA function is used to test whether two values are equal. The function returns 1 if number1 = number2 and 0 in all other cases.DELTA is a useful function if you need to filter a set of values or easy count pairs of equal numbers.
Syntax
=DELTA (number1, [number2])Syntax Breakdown
Number1Required. First number.
Number2
Optional. If omitted, it is assumed to be 0 (zero).
Usage Notes
DELTA tests two numeric values to determine if they are equal. If the values are equal, the function returns 1. If the values are not equal, the function returns 0.DELTA Errors
DELTA returns the #VALUE! error if number1 or number2 is non-numeric.