Count nr of rows if condition meets

[tahirawan11]

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

[etaf]

all the values up to 8 are less then the next row in your example

3.4 is less than 3.6
3.6 is less than 4

etc

I was going to suggest
if the numbers start in A2
then in B2 put
=IF(A2<A3,COUNT($A$2:A2),"")
and copy down

see attached

would you confirm the rules you would like to apply

[Pepe Le Mokko]

Perhaps

Please Login or Register  to view this content.

[tahirawan11]

thanks etaf, this is what i was looking for

[Kevin UK]

Hi tahirawan11

Assuming your data is in A1:A12, in B1 and copy down. Perhaps something like this!

Please Login or Register  to view this content.

[tahirawan11]

Perhaps

Please Login or Register  to view this content.

i tried with the formula but i didnt got the correct answer