I have a bunch of values in a column, 10 rows deep, and would like to check if they are in sequential order. Instead of writing =IF(AND(A1<A2,A2<A3,A3<A4,.... and so on, is there way to do this with a shorter and simpler formula?
Thanks
I have a bunch of values in a column, 10 rows deep, and would like to check if they are in sequential order. Instead of writing =IF(AND(A1<A2,A2<A3,A3<A4,.... and so on, is there way to do this with a shorter and simpler formula?
Thanks
Last edited by luv2glyd; 12-27-2015 at 02:54 AM.
You either quit or become really good at it. There are no other choices.
Try this
=if(sumproduct(if(A1:A9<A2:A10,1,0))=9,"yes","no")
Enter it as an array formula cntr + Shift + enter
Happy with my advice? Click on the * reputation button below
That works well. Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks