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]

Why is row 4 returning a valid value, even if there are blanks in the row?
And why row 6 isn't, though it is the same data as in row 2?

 

[mcva]

Why is row 4 returning a valid value, even if there are blanks in the row?
And why row 6 isn't, though it is the same data as in row 2?

in row 4 all cells before the max (4.7) have values (0 and 2.7))

 

[mcva]

in row 4 all cells before the max (4.7) have values (0 and 2.7))

row 6 is not correct. the output should be 4.7. sorry

 

[AlphaFrog]

Try this...

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

 

[Peter_SSs]

Are the numbers that exist in any row always increasing left to right like in all your examples?

 

[mcva]

Are the numbers that exist in any row always increasing left to right like in all your examples?

yes they are

 

[GraH]

in row 4 all cells before the max (4.7) have values (0 and 2.7))

But the max in that row is 10.7?

 

[mcva]

But the max in that row is 10.7?

output for each row :

row 2: 4.7
row 3 :
row 4 : 4.7
row 5:
row 6: 4.7
row 7: 8.7
row8:
row9
row 10: 12.7

 

[mcva]

Try this...

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

only works in some cells.