CODEWITHSUNDEEP
excel
davidahines
davidahines

Reputation: 4094

How do I get the highest value in a row in excel

I'm looking to compare the value of the max score of a group of people, format is as follows:

date            user1   user2   user3
06/07/2011      123     112     244

How do I determine which of values on the row is the highest? Eg, I would like to pull 244 from this row.

Upvotes: 0

Views: 13813

Answers (2)

Fredrik Pihl
Fredrik Pihl

Reputation: 45634

How about using the max-function?

=MAX(b1:d1)

Upvotes: 4

bcoughlan
bcoughlan

Reputation: 26617

Use the max function in whatever cell you want it in: =Max(A2:A4)

Upvotes: 2

Related Questions