It should block the groups of same values with a true or false value
The TRUE in the example is in cell B2

1 TRUE result true
1 =IF(A2=A3,B2,NOT(B2)) result true
2 =IF(A3=A4,B3,NOT(B3)) result false
2 =IF(A4=A5,B4,NOT(B4)) result false
3 =IF(A5=A6,B5,NOT(B5)) result true
3 =IF(A6=A7,B6,NOT(B6)) result true
4 =IF(A7=A8,B7,NOT(B7)) result false

regards


--
tony h
------------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074
View this thread: http://www.excelforum.com/showthread...hreadid=533936