I have a spread sheet with thousands of sets of numbers. That is too say, there are ten columns and each column has a number - and there are thousands of rows of these numbers.
What I want to do is check whether the numbers on each row is increasing or not. For example, imagine this is row one (with each number being a separate column):
13. 17. 25. 37. 39. 40. 53. 61. 68. 71
As you can see, the numbers are all increasing. Now let's imagine that this is row two:
13 5. 3. 18. 34. 17. 49. 83. 63. 71
In this case the starting and ending numbers are the same as the first set of numbers, but the path taken is quite different.
What I would like is a formula to assess how continuous is the growth.
Any ideas?