I've been looking all over, with no success. I want either a formula or a VBA function to determine if a column is sorted. I've attached the best candidates I've found, both a formula and function based on that formula. However, while it works well to tell me if a column is sorted, it fails if the column contains duplicates. Is there a way to determine if a column of values, which may or may not contain duplicates, is sorted alphabetically?
I appreciate any help I can get.
Bookmarks