How can I identify duplicate consecutive cells, not in adjacent columns but adjacent rows like my sample below:
4/30/2016
5/12/2016
4/5/2016
5/10/2016
5/10/2016
4/30/2016
5/12/2016
5/10/2016
In this example, the 4th and 5th rows contain 5/10/2016, which is the only pair matching the requirement.