Counting how much number is in ascending order in a row.

[motilulla]

Using Excel 2010
Hello,

I need a Formula or VBA which can count numbers are ascending order in a row. From the 1st starting number, for example…..

Row1 (4-7-8-10) =4, row2 (4-7-18) =3, row3 (4-7) =2, row5 (4-7-8-10-39) =5

n1	n2	n3	n4	n5	Ans
4	7	8	10	9	4
4	7	18	10	9	3
4	7	12	10	29	2
4	7	8	10	39	5

Regards,
Moti

 

[Peter_SSs]

Thanks for the clarification. Try this

24 02 26.xlsm
	A	B	C	D	E	F
1	n1	n2	n3	n4	n5	Ans
2	4	7	8	10	9	4
3	4	7	18	10	9	3
4	4	7	12	10	29	3
5	4	7	8	10	39	5
6	15	12	10	8	7	1
7	4	7	6	8	9	2
8	21	21	21	31	41	0
9	21	21	22	34	45	0
10	21	22	22	35	41	0
11	21	24	24	39	44	0
12	21	21	21	21	49	0
13	26	26	29	29	48	0
14	21	22	34	34	45	0
15	21	22	18	18	45	0
16	21	22	22	18	48	0
Ascending (2)

Cell Formulas
Range	Formula
F2:F16	F2	=IFERROR(MATCH(TRUE,B2:E2<A2:D2,0),5)*(MAX(COUNTIF(A2:E2,A2:E2))=1)
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[motilulla]

Thanks for the clarification. Try this

24 02 26.xlsm
	A	B	C	D	E	F
1	n1	n2	n3	n4	n5	Ans
2	4	7	8	10	9	4
3	4	7	18	10	9	3
4	4	7	12	10	29	3
5	4	7	8	10	39	5
6	15	12	10	8	7	1
7	4	7	6	8	9	2
8	21	21	21	31	41	0
9	21	21	22	34	45	0
10	21	22	22	35	41	0
11	21	24	24	39	44	0
12	21	21	21	21	49	0
13	26	26	29	29	48	0
14	21	22	34	34	45	0
15	21	22	18	18	45	0
16	21	22	22	18	48	0
Ascending (2)

Cell Formulas
Range	Formula
F2:F16	F2	=IFERROR(MATCH(TRUE,B2:E2<A2:D2,0),5)*(MAX(COUNTIF(A2:E2,A2:E2))=1)
Press CTRL+SHIFT+ENTER to enter array formulas.

Peter_SSs, you made my day thank you for giving a perfect solution for my second request.

I appreciate the help and the time you spent.

I wish for you have a good time and good luck.

Kind Regards,
Moti

 

[Peter_SSs]

Glad to help.