Are identical items grouped together in a column

I want a formula (no VBA) that returns TRUE(and FALSE otherwise) if a specific column is organized such that identical items in that column are all grouped together. Examples: If B1 to B7 contains 8,8,7,9,9,9,6, the formula returns TRUE because the 8s, the 7s, the 9s and the 6s are all grouped together. If B1 to B10 contains 3,3,3,3,1,9,9,3,6,6, the formula returns FALSE becuse the 3s are not grouped together although the 1s, the 9s and the 6s are grouped together

By: Raj

Leave a Reply

Your email address will not be published. Required fields are marked *