Retrive the maximum value of a row, only if the entire row is filled with values. Can this be done without vba?

[mcva]

Hello, I have several sheets with this kind of format (7000 rows)
The output I need is the maximum value in each row. But I only want to retrive the value if the corresponding row is filled with values ...
Can this be done without vba?
Thank you.

 

[GraH]

What about
=IF(B2="","",IFERROR(INDEX(A2:G2,AGGREGATE(14,6,COLUMN(A2:H2)/(COLUMN(A2:H2)<AGGREGATE(15,6,COLUMN(A2:H2)/((A2:H2)=""),1)),1)),""))

Book1
	A	B	C	D	E	F	G	H	I
1
2	0	2,7	4,7						4,7
3	0
4	0	2,7	4,7			10,7			4,7
5	0			6,7	8,7	10,7
6	0	2,7	4,7						4,7
7	0	2,7	4,7	6,7	8,7				8,7
8	0			6,7	8,7	10,7
9			4,7	6,7	8,7	10,7	12,7
10	0	2,7	4,7	6,7	8,7	10,7	12,7		12,7
Sheet1

Cell Formulas
Range	Formula
I2:I10	I2	=IF(B2="","",IFERROR(INDEX(A2:G2,AGGREGATE(14,6,COLUMN(A2:H2)/(COLUMN(A2:H2)<AGGREGATE(15,6,COLUMN(A2:H2)/((A2:H2)=""),1)),1)),""))

 

[mcva]

What about
=IF(B2="","",IFERROR(INDEX(A2:G2,AGGREGATE(14,6,COLUMN(A2:H2)/(COLUMN(A2:H2)<AGGREGATE(15,6,COLUMN(A2:H2)/((A2:H2)=""),1)),1)),""))

Book1
	A	B	C	D	E	F	G	H	I
1
2	0	2,7	4,7						4,7
3	0
4	0	2,7	4,7			10,7			4,7
5	0			6,7	8,7	10,7
6	0	2,7	4,7						4,7
7	0	2,7	4,7	6,7	8,7				8,7
8	0			6,7	8,7	10,7
9			4,7	6,7	8,7	10,7	12,7
10	0	2,7	4,7	6,7	8,7	10,7	12,7		12,7
Sheet1

Cell Formulas
Range	Formula
I2:I10	I2	=IF(B2="","",IFERROR(INDEX(A2:G2,AGGREGATE(14,6,COLUMN(A2:H2)/(COLUMN(A2:H2)<AGGREGATE(15,6,COLUMN(A2:H2)/((A2:H2)=""),1)),1)),""))

What about
=IF(B2="","",IFERROR(INDEX(A2:G2,AGGREGATE(14,6,COLUMN(A2:H2)/(COLUMN(A2:H2)<AGGREGATE(15,6,COLUMN(A2:H2)/((A2:H2)=""),1)),1)),""))

Book1
	A	B	C	D	E	F	G	H	I
1
2	0	2,7	4,7						4,7
3	0
4	0	2,7	4,7			10,7			4,7
5	0			6,7	8,7	10,7
6	0	2,7	4,7						4,7
7	0	2,7	4,7	6,7	8,7				8,7
8	0			6,7	8,7	10,7
9			4,7	6,7	8,7	10,7	12,7
10	0	2,7	4,7	6,7	8,7	10,7	12,7		12,7
Sheet1

Cell Formulas
Range	Formula
I2:I10	I2	=IF(B2="","",IFERROR(INDEX(A2:G2,AGGREGATE(14,6,COLUMN(A2:H2)/(COLUMN(A2:H2)<AGGREGATE(15,6,COLUMN(A2:H2)/((A2:H2)=""),1)),1)),""))

It works thank you so much

 

[mcva]

Try this...

=IF(SUMPRODUCT(MAX((A2:G2<>"")*(COLUMN(A2:G2))))=COUNTA(A2:G2),MAX(A2:G2),"")

I think that you solution works. I have a problem with my pc and or excel

 

[mcva]

Try this...

=IF(SUMPRODUCT(MAX((A2:G2<>"")*(COLUMN(A2:G2))))=COUNTA(A2:G2),MAX(A2:G2),"")

Thank you for your help

 

[Peter_SSs]

yes they are

Thanks. Then depending on your exact circumstances, you could also try any of these.

20 04 22.xlsm
	A	B	C	D	E	F	G	H	I	J	K
1
2	0	2.7	4.7						4.7	4.7	4.7
3	0
4	0	2.7	4.7			10.7			4.7	4.7	4.7
5	0			6.7	8.7	10.7
6	0	2.7	4.7						4.7	4.7	4.7
7	0	2.7	4.7	6.7	8.7				8.7	8.7	8.7
8	0			6.7	8.7	10.7
9			4.7	6.7	8.7	10.7	12.7
10	0	2.7	4.7	6.7	8.7	10.7	12.7		12.7	12.7	12.7
Sheet2 (3)

Cell Formulas
Range	Formula
I2:I10	I2	=IF(COUNT(A2:B2)=2,INDEX(A2:G2,MATCH(1,(B2:H2="")*(A2:G2<>""),0)),"")
J2:J10	J2	=IF(COUNT(A2:B2)=2,INDEX(FILTER(B2:F2,(B2:F2<>"")*(C2:G2=""),G2),1),"")
K2:K10	K2	=IF(COUNT(A2:B2)=2,IF(COUNTBLANK(A2:G2),MINIFS(B2:G2,B2:G2,"<>",C2:H2,""),G2),"")