I have a column of data with random numbers. The number of rows with data
varies depending on another formula. I am trying to write a seprate formula
that will automatically give me the last value in the column no matter what
row it is in.

45, 44, 46, 12, , , , , (Would want it to return 12)
45, 44, 46, 12, 32, 17, 53, , (would want it to return 53)