Thread: Sort isn't sorting correctly
View Single Post
  #3   Report Post  
mikerickson mikerickson is offline
Junior Member
  
Location: Winters CA
Posts: 22
Default
Quote:
Originally Posted by GARYWC View Post
Is there a formula/function (not a macro!) that I can use to verify whether the cells are in ascending order?
A formula like
=(SUMPRODUCT(--(A1:A100<"")*(A1:A100<=A2:A101))=(COUNTA(A1:A100)-1))

should work
Reply With QuoteReply With Quote