0 or 1 return.

[serge]

Hi,
I'm looking for a formula to put in G4 to drag right and down that will return a 0 if the digit above is different and a 1 if the digit above is the same from the table in green.

Thank you.

 

[Rick Rothstein]

Put this formula in cell G4 and copy it across to J4, then copy G4:J4 down to Row 11...

=0+(B3=B4)

 

[serge]

Wow so quick, Thank you Rick always appreciated.