i have row totals in a range that is H5:H25, but some cells in this range may have nill value (despite that formula exists). i want to show the last value in this range in cell H27.
suppose i have a value in H5, H6, and H7 (remaining cells i-e H8:H25 have nill value) i want to show in H27 the last value in that range which is now in H7.
similarly if the values in range H5:H25 change the cell H7 should automatically update to the last value appearing in H5:H25.

is there any way?
your expert advice will be appreciated.
i m waiting for quick reply.
thanks.