=if(countif(n1:s1,z1)0,1,0)
or
--(countif(n1:s1,z1)0)



Hannes wrote:

Hi,

I please need some support for to program the following macro:
the value of column Z in a row should be compared with the values in columns
N to S in the same row (values in comparison are dates). The output of the
comparison should be input in column T of the same row. If no matching values
(dates) are found the output value = 0, match value = 1.

Please let me know when this description needs to be refined.

I greatly appreciate any support!

--

Dave Peterson