13 Replies Latest reply: Aug 8, 2014 4:39 AM by sujeet singh RSS

    Next row value

      Hello,

       

      I have a spreadsheet which requires the next row of data so that I can calculate the closing stock of the day before (i.e. users only input the opening stock per day and thus I need to look at the next days opening stock to calculate the closing stock of the previous day)

       

      DateOpening StockClosing Stock
      26/03/1323445000
      27/03/1350006780
      28/03/1367809000
      29/03/1390001000

       

      So for the above example for the 27/03/13 I currently only have the opening stock of 5000 inputted and I need to look at the 28/03/13 opening stock in order to complete the closing stock for 27/03/13. Obviously peek could be used if I was looking for the previous value but I'm not sure as to how to look at the next field value.

       

      Thanks,


      Ralph