With highest value on given range

[A P]

Hi!

I need help with my data as seen below:

A B C D E F
G H (Result)

1 UserA 750 750 1500 1500 1500 750
1500 (Highest Value From B1 to G1)
2 UserB 2000 560 1301 1800 1760 255
2000 (Highest Value From B2 to G2)

What formula do I need to do to look for the highest value from the given
range of cell?

Hope you'll response. I need it very much.

Me

 

[Domenic]

H1, copied down:

=MAX(B1:G1)

Hope this helps!

 

[A P]

thanks. It really help a lot!

Me

H1, copied down:

=MAX(B1:G1)

Hope this helps!