Home > Excel, Formulas > Checking if a range is sorted with a formula

Checking if a range is sorted with a formula

May 18th, 2011 admin

January 7th, 2011

To test if range B2:B8 is sorted use {=AND(AND(B2:B7<=B3:B8)<>AND(B2:B7>=B3:B8))} in Excel
To enter a array formula ( and get the brackets ) you need to put the formula in without the brackets and press Control+Alt+Enter

thnx to Chandoo.org

Categories: Excel, Formulas Tags: ,
Comments are closed.