Find the highest number in a row of numbers

[reykev]

I am generating random numbers in a row. Using 100 columns for number generation on that row, and am doing it on several rows. Manually looking to find the highest number is real slow. Is there a formula for finding the highest number in each row?

Thanks in advance.

Kevin

[mark_t]

Use the MAX function

For a single row from A to Q

=MAX(A1:Q1)

Or could be used for multiple rows, example for rows 1 to 10:-

=MAX(A1:Q10)

[mark_t]

Use the MAX function

For a single row from A to Q

=MAX(A1:Q1)

Or could be used for multiple rows, example for rows 1 to 10:-

=MAX(A1:Q10)