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!

=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