Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try RangeMax()
RangeMax(V1, V2, V3, V4, V5)
Hi Sunny
Thanks for suggestion
Did it work or not?
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