Subscribe Bookmark RSS Feed

How to create a formula column to find the maximum of several columns

adampaulsmith

Community Trekker

Joined:

Sep 17, 2012

I have several columns of numeric data (see example below) and I would like to create a formula column to find the maximum value for each row across the columns.  Any help would be appreciated.  Thank you!

Value 1      Value 2      Value 3      Max Value (I would put the formula in this column)

1                    9               6                    9

2                    1               5                    5

3                    7               4                    7

4                    2               6                    6

1 ACCEPTED SOLUTION

Accepted Solutions
Solution

Max(:Value 1, :Value 2, :Value 3)

2 REPLIES
Solution

Max(:Value 1, :Value 2, :Value 3)

adampaulsmith

Community Trekker

Joined:

Sep 17, 2012

Thanks ! I knew it had to be something simple.