Max value out of five columns

[Anonymous]

Hi

I have data as below

Location  V1  V2   V3   V4   V5

USA          2    0      0     3      0

Canada     0    0      4     7     1

Mexico      0    4     3     2      0

India          2    2    0     0      0

The goal is as below adding last column with highest value from column through V1 to V5

Location  V1  V2   V3   V4   V5 Value

USA          2   0      0     3      0    3

Canada     0   0      4     7     1     7

Mexico      0    4     3     2      0    4

India          2    2    0     0      0     2

Thanks in advance for your guidance

[sunny_talwar]

Try RangeMax()

RangeMax(V1, V2, V3, V4, V5)

[Anonymous]

Hi Sunny

Thanks for suggestion

[sunny_talwar]

Did it work or not?

[Anonymous]

Hi Sunny

Sorry for late reply, some problem in my PC.

But yes it works nice.

Thanks for your suggestion

Sorry for late reply again