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

2019-09-16 07:19发布

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.

标签: excel
2条回答
虎瘦雄心在
2楼-- · 2019-09-16 07:55

How about using the max-function?

=MAX(b1:d1)
查看更多
Bombasti
3楼-- · 2019-09-16 08:04

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

查看更多
登录 后发表回答