SyntaxFix
Write A Post
Hire A Developer
Questions
If you have the data sorted.. i suggest using the following formula
=IF(OR(A2<>A3,B2<>B3),1,0)
This is faster as it uses less cells to calculate.