Did you ever need a worksheet function to determine if a range is sorted? Neither have I. But I’m all about answering questions that haven’t been asked.
=SUMPRODUCT(--(A1:A10>=A2:A11))=--(A11<a10 ) The SUMPRODUCT part compares every cell in the range to the one below it. If any cell is greater than the one below it, it [...]
Read More...
Read the complete post at http://www.dailydoseofexcel.com/archives/2011/04/20/worksheet-function-to-test-if-range-is-sorted/
Posted
Apr 20 2011, 07:30 AM
by
Daily Dose of Excel