I have answered the OPs original question (test whether or not a range of numbers is in ascending order) using SUMPRODUCT and an offset range. However, the OP has now let it slip that there can be blank cells. I can't figure it out...

http://www.excelforum.com/excel-form...ncreasing.html