Help with MaxString!

[#1]

Hi All

In one of our application. Month is considered as A1,A2..A12. To get the max of month in this format I have been using MaxString(MONTH). Looks like it is not working as expected as the max(MONTH) should be A10 but it is still displaying A9 as the max of month.

Please let me know what function will give the result that I need.

Thanks

Attitude

[SunilChauhan]

see the attached file

hope this helps

[#3]

Hi Sunil

Can you please do everything in the script level instead of using variable.

Thanks

Attitude

[#4]

Hi All

If month contains A1,A2,A3,A4,A5,A6,A7,A8,A9 and A10. Function should return A10 as the max(month).

Thanks

Attitude

[SunilChauhan]

see the attached file

hope it make you haapy