13 Replies Latest reply: Apr 19, 2010 7:56 AM by umangu2000 RSS

    Getting the Min & Max values for the selected period

      Hi,

      For my analysis I need to select a particular period in days and need to get the corresponding values of the Prices for the selected period.

      For example:

       

       

      DayPrice
      11000
      21008
      31008
      41017
      51025
      61028
      71037
      81037
      91042
      101046
      111051
      121057
      131058
      141064
      151070
      161077
      171078
      181082
      191092
      201101
      211109
      221109
      231118
      241129
      251137
      261145
      271155
      281160
      291170
      301178

       

      Lets say I select the preiod starting from Day 20 - Day 30 - I need a formula to get 1101 (the price on day 20) and 1178 (the price on day 30. The price needs to change as and when the selection is made

      Please help