Hi ,
I have a requirement as below:
Year Demand
01/2009 300
02/2009 800
03/2009 500
04/2009 900
05/2009 400
I need show a column which indicates the max demand value among the 5 months.
like for this example the max value is 900.
I tried the data function MAX but the MAX function is for only 2 values and not for than 2 values.
Thanks In Advance.