If row is less than last row

[Kevineamon]

Hi guys

Struggling with a little problem here, should be really simple you'd image, but danged if I can get it to work:-
this below, is basically the idea I need to happen.

If column A suddenly goes lower than the previous value, increment column b by 1. Can't use scripts.

1 | 0
2 | 0
3 | 0
4 | 0
5 | 0
1 | 1
2 | 1
3 | 1

 

[Scott T]

Is this what you want?

Book1
	A	B
1	1	0
2	2	0
3	3	0
4	4	0
5	5	1
6	1	1
7	2	1
8	3	1
Sheet1

Cell Formulas
Range	Formula
B1	=IF(A2)
B2	=IF(AND(A3<>""),B1+1,B1)
B3	=IF(AND(A4<>""),B2+1,B2)
B4	=IF(AND(A5<>""),B3+1,B3)
B5	=IF(AND(A6<>""),B4+1,B4)
B6	=IF(AND(A7<>""),B5+1,B5)
B7	=IF(AND(A8<>""),B6+1,B6)
B8	=IF(AND(A9<>""),B7+1,B7)

 

[Kevineamon]

Great Scott! Soz :P Almost Almost...

The increment in column B, shouldn't happen, till column A goes to 1.

 

[Scott T]

Book1
	A	B
1	1	0
2	2	0
3	3	0
4	4	0
5	5	0
6	1	1
7	2	1
8	3	1
Sheet1

Cell Formulas
Range	Formula
B1	=IF(A2)
B2	=IF(AND(A2<>""),B1+1,B1)
B3	=IF(AND(A3<>""),B2+1,B2)
B4	=IF(AND(A4<>""),B3+1,B3)
B5	=IF(AND(A5<>""),B4+1,B4)
B6	=IF(AND(A6<>""),B5+1,B5)
B7	=IF(AND(A7<>""),B6+1,B6)
B8	=IF(AND(A8<>""),B7+1,B7)

 

[Kevineamon]

Mmm it's something similiar to what I have, though I need it to autoupdate. Tell you what, all I need now is this


FALSE | 0
FALSE | 0
FALSE | 0
TRUE | 1
FALSE | 1
FALSE | 1

Usually I could do that without a problem but my brain is burnt out thinking about it.

I've a Rows(c$2:c2) column set up next to it acting like a clock.
I just need to +1 at the true value, for all the next rows...

 

[Scott T]

Does this do what you need?

Book1
	A	B
1	FALSE	0
2	FALSE	0
3	FALSE	0
4	TRUE	1
5	FALSE	1
6	FALSE	1
7	FALSE	1
8	TRUE	2
Sheet1

Cell Formulas
Range	Formula
B1	=COUNTIF($A$1:A1,TRUE)
B2	=COUNTIF($A$1:A2,TRUE)
B3	=COUNTIF($A$1:A3,TRUE)
B4	=COUNTIF($A$1:A4,TRUE)
B5	=COUNTIF($A$1:A5,TRUE)
B6	=COUNTIF($A$1:A6,TRUE)
B7	=COUNTIF($A$1:A7,TRUE)
B8	=COUNTIF($A$1:A8,TRUE)

 

[Kevineamon]

Thx, I didnt use this exact method, but it's something similar. It's working great now thanks for the help.