MS Excel: formulas that make your work easier

# To return a latest value of a column. (the column can not have empty cells between 1st value and last value)

=INDEX(H8:H14,COUNT(H8:H14))


in this formula, the range H8 to H14 we will get the latest value or the bottom most value in the correspondent cell that hold this formula.

Explanation:
count formula here counts the number of cells that has values.
using index formula, we find the index value within the given range, in this case H8:H14, and we want the index value of the 5th cell that is from top to down (the last cell with the values), which is the value given from Count formula.