Ask Your Question
0

find the highest number in a row of numbers

asked 2016-07-21 03:10:12 +0200

reykev gravatar image

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

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
1

answered 2016-07-21 04:34:51 +0200

mark_t gravatar image

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)
edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2016-07-21 03:10:12 +0200

Seen: 2,457 times

Last updated: Jul 21 '16