Hi,

I have data as following example in col A

3.4
3.6
4
4.6
6.7
7
8
8.5
7.6
6
5
4

I want to count the nr of rows from start; when the value in the next row becomes less than the previous row. For eg in the case about it would be row nr 8 as 7.6 is less than 8.5. can anyone tell me what function can be used for this.

/tahir