Forum Discussion

jracer007's avatar
jracer007
Helper IV
8 years ago
Solved

Last value

Hello community, I want you to help me by creating a measure to take the last value of a column: https://docs.google.com/spreadsheets/d/1tJD3U_IWL1PX9CwToPW9vk2-YTT-rIJLTqJtqzt02KU/edit?usp=sharing ...
Need Help
  • zayan's avatar
    zayan
    8 years ago

    Hi,

    You could use the below formula to return the last value of the column.

    (This is to get the last value of column A)

     

    =INDEX(A:A,MAX((A:A<>"")*(ROW(A:A))))