When values are equal, DELTA returns 1.
When values are different, DELTA returns zero.
As a result, DELTA can be used to easily count pairs of equal numbers.
For example:
In the example shown, the formula in D6, copied down, is:
Notes:
DELTA Function
The Excel DELTA function will test if two numeric values are equal. When values are equal, DELTA returns 1, otherwise, DELTA returns zero.
