1 2 Previous Next 15 Replies Latest reply on Nov 26, 2013 2:40 PM by George Nguyen

    Is there a formula that will grab the last available value within a data set?

    George Nguyen

      Hi,

       

      I am working with World Bank data that doesn't have the current year's measurement available for certain data sets. Is there a formula that will return only the last reported/available measurement?

       

      Essentially, I want to be able to display the following results based on the data available in the table:

       

      Euro area: Internet users = 76 | Mobile cellular subscription = 125 | Motor vehicles = 593 | Population = 333,791,352

      sparse data.PNG.png

        1 2 Previous Next